Deleting record created in Access stored in SqlServer

[Guest]

I have Access 2003, supervisor created a SQLServer database that I connect
into. Access 2003 (11.6355.6360) SP1

(When I open the Access database, the form says that it is an Access 2000
file format).

I can create a record in the SQL database via Access, but I cannot delete
the record. I get a message which says that another user is trying to do the
same thing.

Here is the message that I get when I try to delete a record (and it's not
the only record):

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

Any suggestions?

 

[Ron Hinds]

I have Access 2003, supervisor created a SQLServer database that I connect
into. Access 2003 (11.6355.6360) SP1

(When I open the Access database, the form says that it is an Access 2000
file format).

I can create a record in the SQL database via Access, but I cannot delete
the record. I get a message which says that another user is trying to do the
same thing.

Here is the message that I get when I try to delete a record (and it's not
the only record):

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

Any suggestions?

Is it a bound form? Set the Default Record Locking to Edited Record. If the
changes are done by code, make sure any Recordsets opened are only open as
long as needed and are closed properly as soon as possible. I've seen that
behavior when Recordset A is opened on a table, then Recordset B is opened
on the same table while A is still open and B tries to update.