I'm afraid this problem has been mentioned more than once on the experts-exchange before.
I tried all suggestions for solutions that I could find, but I can't seem to fix the problem:
I just upgrade my MS SQL from MSDE to MSSQL 2005, and a frontend created in Ms Access 2003, connecting to the database using ODBC connection.
I am using SBS 2003 for the Server, and WinXp for the workstations (10 PC)
I can added new records with no problem to the table via the form, but if I try to update or delete existing records, I get the error:
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.
Copying the changes to the 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.
This problem just happened after using MS SQL 2005, and only a few computers have this problem.
I checked all the MS Access references, the version for the OS + MS Office. All are the same between the workstation that have a problem and the one that working.
Any assistance greatly appreciated!
Cheers and thanks,