write Conflict (1 Viewer)

[Jaspal]

Hi All,

I have an access from end application with linked tables to SQL server. The tables are access by many users at the same time (multi user enviroment). The Users are able to scroll through, edit etc the records. However now and again users are getting the message box that there is a "write conflict", at first i thought it was when the users were in the same record at the same time, but this is not the case.

I am currently searching for other answers and will carry on to do so. However if anybody has a solution or suggestion that would be great!

Many thanks in advance

 

[llkhoutx]

Take a look at

Transmit/Commit/Rollback

Those VBA processes allow a user to catch a write conflict. Unfortunately they require code on a Rollback depending on one's requirements.

Anyone hitting a record while the first person has the record locked can lose their updates if they're not careful. Hence, the Rollback.