Write Conflict Error Message 1

[Kindi]

I have a SQL server DB, and the data is added by Access Forms 2000 front end, via linking tables. I have never come across this problem before, but when the a form is in edit mode of a particular table, when a user edits the data, and clicks to move to the next record, a write conflict message appears:

'This record has been changed by another user since you started editing it. If you save the record, you will overite the changes the other user made.

Copying the changes to teh clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes'

There are options to then 'Copy to Clipboard' or 'Drop Changes'.

No other user is using the database, and the other forms are ok. I am not sure why this message is appearing and i cant edit the data. I have redone the form and still get the same error. Please Help

Thanks
Kindi

 

[JaneC]

Hi,

Don't know if this will help but I had a similar problem just using Access97. I resolved it by adding a line of code to the "NextRecord" control to save the record before moving to the next one.

HTH

Jane

 

[Kindi]

Thanks, your reply sounds the right thing to do, but what is the VBA code to save a record.

Thanks
Kindi

 

[JaneC]

Kindi,

This is the code for 97.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Otherwise you can do what I usually do and cheat !
Add a command button with the wizard to save the record, copy the code line into the relevant control and then delete the command button and the code associated with it.

Jane