Recently a key student information table that I've been working on was corrupted while I was demonstrating the database to staff while the Server was having a service pack installed.

The Access client started to run slowly and then I got an error message (3197) stating that it was not possible to save this record because another user is writing to this record. The client then lost its connection to MS SQL Server because the Server was rebooting.

So I slogged through all of the possible causes until I found out that Server had been upgraded during my training session with the office staff.



The table had been corrupted, it wouldn't save data by a number of different methods. I've had to do another data transfer and since then this problem has not re-occurred.

I've been told that the upgrade is not to blame for this damage but I still believe that the server upgrade is the most likely cause of this problem, has anyone encountered this issue before ?