Bachground:I have an access data base front end, who's tables are linked to an sql server backend. In turn the tables are connected to the Forms Dinamically. For example: ME.recordSource = "SELECT * FROM tblCustomers WHERE loc = '" & location "'"

Theres one main form with about 5 Subforms connected to it all placed on tabs. About 3 of the forms record sources refer to the same table.

When I have the main form on the last record and I try to delete a record on one of the particiular subforms I get the following message.

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

In all other circumstances it deletes fine it only does this when the main form is on the last record. What can I do to fix this, or get around this. I don't mind long answers. Thanks in advance.

Re: Edit Record Error


Well what do know. I thank God for helping me find this answer. The answer is That on the SQL Server side you can't have a Bit field with a null value or it will lock that record. The key is to either on the Access/Client side have the form apply a default value to that specific field or to to enter in a default value on the SQL Server side. There are many things that can cause this error, But this was the correct solution for me.