Updatable table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MM - 29 Aug 2005 21:12 GMT

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

Reply to this Message

Sylvain Lafontaine - 29 Aug 2005 21:27 GMT

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

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I created an Access Data project to connect to an existing SQL Server
>database.
[quoted text clipped - 8 lines]
>
> - Mike

Reply to this Message

MM - 29 Aug 2005 21:32 GMT

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

Primary key is defined.

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

Reply to this Message

MM - 29 Aug 2005 21:42 GMT

>> Probably a missing primary key. There are other possibilities, too.
>
> 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.

Reply to this Message