February 9, 2011 at 12:12 pm
I am using MS Access 2003 and SQL Server 2003.
In my MS Access database have a linked table that resides in a database in my SQL Server.
From the linked table I can add a new record.
When I attempt to edit that record (even after exiting the database and reopening it) I get the following message:
Write Conflict: This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Etc., etc.
The “Save Record” button is disabled, only the Copy to Clipboard and Drop Changes buttons are enabled.
When I attempt to delete the record 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.”
I am the only user accessing this SQL Server table.
I can edit or delete records that have been entered directly into the SQL Server database table (not from the linked table in MS Access).
I have another linked SQL Server table that doesn’t have this problem. I can add/edit/delete just fine. I’ve compared the data structure of both tables and can find no difference other than the field names. I’ve even created a new SQL Server database table with the same structure, imported the data into it, and still have the same problem. I’ve checked the indexes and constraints (even deleted them) and the problem remains.
Thanks for any suggestions you might have.
February 11, 2011 at 5:13 am
Have you got a boolean (yes/no) field in it?
May sound weird but make sure it has a default value of 0.
I would say: Test without the boolean field: See if you still have that problem without that field.
Also: Make sure you have a proper Primary key.
Regards,
Henk
February 11, 2011 at 8:23 am
Henk,
Thank you for the reply. I thought I had placed a default for the yes/no field but found that I hadn't. Problem solved.
Jay Myhre
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply