Cant add/edit/delete records in Access Data Project

[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

 

[Douglas J. Steele]

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.

 

[CJM]

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.

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

Thanks Douglas.