Updatable table

[MM]

I created an Access Data project to connect to an existing SQL Server
database.

I connected using the "sa" login name.

I cannot edit the data in the tables. Tells me "recordset not updatable".

Is there a setting in Access for read/write permissions.

I can edit everything using Enterprise Manager using the "sa" login name.

- Mike

 

[Sylvain Lafontaine]

Probably a missing primary key. There are other possibilities, too.

 

[MM]

Probably a missing primary key. There are other possibilities, too.

Primary key is defined.

This is not a multi-table query, just a table.

 

[MM]

Primary key is defined.

This is not a multi-table query, just a table.

Actually, you were right. The primary key was missing.
It used to have one.