Hi there, shortly I will be investigating an issue regarding an Access 2007 database which is supposedly "corrupted", and some time last week it lost 55,000 records. The details of what went wrong and caused the corruption are very unspecific, all I know is that it happened at some point between Wednesday, and Friday and at one point a compact was performed.
This is a database that is used in a multi-user enviroment. As far as I'm aware, it's not possible for 55,000 records to be lost over a network. Even if some large operation was halted that was selecting 55,000 records from a table, because of the 4k page-locking packet size limit there's no way that as many as 55,000 should be lost. Apparently those 55,000 records took up about 57MB.
Also, from the sounds of things, it's being labeled as a "corruption" but there isn't actually any sort of corruption message... I'm more inclined to believe that a user accidently ran a delete query or was getting a little too friendly with the Ctrl + X keys.
Thoughts? Comments?
This is a database that is used in a multi-user enviroment. As far as I'm aware, it's not possible for 55,000 records to be lost over a network. Even if some large operation was halted that was selecting 55,000 records from a table, because of the 4k page-locking packet size limit there's no way that as many as 55,000 should be lost. Apparently those 55,000 records took up about 57MB.
Also, from the sounds of things, it's being labeled as a "corruption" but there isn't actually any sort of corruption message... I'm more inclined to believe that a user accidently ran a delete query or was getting a little too friendly with the Ctrl + X keys.
Thoughts? Comments?