Edit SQL Server data via an ADP

[CJM]

We have a some data in SQL Server that we want a small number of users to be
able to edit, so and Access Data Project seemed like the correct route to
take.

However, having created the ADP file, and linked to the SQL Server, it shows
the right tables but wont let us change any values in the tables.The
connection uses Windows Authentication and all the relevant users have
permissions to edit the data in SQL Server. Hell, in the DBA and even I
can't edit it.

So I'm obviously missing something... anyone got any ideas?

Thanks in advance

Chris

 

[Uri Dimant]

CJM
Why not create a new GROUP for these users and grant them login to SQL
Server. Don't put the login in ssyadmin server role, instead assign an
appropriate permissions , for more details please refer to the BOL.

 

[CJM]

CJM
Why not create a new GROUP for these users and grant them login to SQL
Server. Don't put the login in ssyadmin server role, instead assign an
appropriate permissions , for more details please refer to the BOL.

Uri,

I'm an idiot - there was no primary key set, which of course is essential
for editing...!

I've created a primary key, and it works fine.

Thanks for your help

Chris

 

[Dan Guzman]

Tables must have a primary key or unique column list in order to be
updatable from Access.

 

[CJM]

Tables must have a primary key or unique column list in order to be
updatable from Access.

--
Hope this helps.

Dan Guzman
SQL Server MVP

It would have done an hour ago! lol

Thanks anyway..

Chris

 

[lll]

dddd