Access Connection to SQL Server Table: Locking Error

[Scott]

I am working in Access 2003 with a mdb that has linked tables. The
linked tables are on a SQL server.

Trying to work with one of the tables, I am getting an error saying,
The Microsoft Jet Database engine stopped the process because you and
another user are attempting to change the same data at the same time.

I am the only one in the table and I am working directly on the table.
I get the error when I try to delete a row or make and changes.

If I access the table using SQL Server Enterprise Manager, I have no
trouble with the table. I can delete rows and make changes that way.

I tested to see if the data might be corrupted by importing the table
into the mdb file. When the table is native in the mdb, I have no
problems with it.

Anyone know what might be going on here?

Thanks in advance for any help!

 

[Albert D. Kallal]

Check for null bits...

ACC2000: Write Conflict Error When You Try to Update Records in a Linked SQL
Server Table
http://support.microsoft.com/?id=280730

In addition, add a time stamp field to each table. And, even better is to
make sure all tables have a primary key field....
make sure if you are using a "view" from sql server, include both the
timestamp + pk in the view....