Linked SQL Server table allows new records but cannot Edit or Delete

[kook87]

As part as an Access application, I have several linked SQL Server tables. One of the tables allows me to add a record, but when I try to Edit a record or delete the record, I get a message saying that the Jet Engine cannot commit my change because someone else has changed the record already.

I have verified that I am the only person connecting to the DB. I do have write, edit, delete, read permissions on the table. I have re-linked the table and even had the table dropped and re-created .. with the same issues. I do not have this problem on all tables, just this table. Also, I do not have this issue on my laptop, only in the production networked application. Is this an ODBC driver issue? Has anyone had any issues like this?

Thanks,
E

 

[cmmrfrds]

First, make sure there is an unique index defined when you link the table. If you can add a field of data type timestamp to the table, that will probably solve the problem. Is there a field of bit data type in the table, these are usually related to the type of problem you are having on the linked table.

 

[willir]

Here is a link to a pretty good document...
Harnessing the Power of Updatable Queries