Posted on 2009-05-19
I have been running a medical application successfully in one hospital for ~4 years. It consists of an MS Access GUI with SQL server backend. I have recently created a second instance on a virtual server in another institution, using same GUI, same SQL database. However, I am now getting write conflict messages from the Access GUI. This occurs even when a single record is being accessed by a single user, although multiple users may be accessing the same table concurrently. MS Access is set to 'No lock'.
This does not occur in the first institution, and I suspect there may be something causing this in the 2nd environment, but cannot figure it out. Any help or suggestions would be gratefully received.