Edit SQL Server data via an ADP

  • Thread starter Thread starter CJM
  • Start date Start date
C

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
 
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 Dimant said:
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.
Click to expand...

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
 
Tables must have a primary key or unique column list in order to be
updatable from Access.
 
Dan Guzman said:
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
Click to expand...

It would have done an hour ago! lol

Thanks anyway..

Chris
 
Back
Top