Cant add/edit/delete records in Access Data Project

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

CJM

I'm sure I've had this working in the past...

I have created an ADP to allow some users access to an SQL DB. I have
created a db user which has dbo privileges to the database in question, and
I used this account when configuring the connection in the ADP.

However, when I open the tables up in Access, I can add/edit or delete any
records.

I tried modifying the connection to use Windows Authentication, and although
I am a Domain Administrator with full privileges to the SQL Server, this
didnt make any difference.


Can anybody point me in the right direction?

Thanks

Chris
 
I assume you meant to say that you cannot add/edit or delete.

Do you have primary keys defined for all of the tables? They won't be
updatable through an ADP unless you do.
 
Douglas J. Steele said:
I assume you meant to say that you cannot add/edit or delete.

Yes.

Do you have primary keys defined for all of the tables? They won't be
updatable through an ADP unless you do.
Click to expand...

[Sigh] I had recreated the DB without recreating the Keys!

Thanks Douglas.
 
Back
Top