Why are all of my access 2007 DBs getting corrupted?
Posted on 2011-04-21
All of my databases are split. They never been a problem up until recently. Now whenever trying to make changes or when running a compact/repair on the ACCDB file I get an error like "Record is deleted", or "Not enough memory to perform command", or "Database is not in recognized format". All errors which lead to a corrupted DB.
It seems as if this is occurring when the ACCDB file is stored on a network drive. I have all my accdb files stored in My Documents which is directed to the file server by group policy. I've stored my DBs like this for over a year and never had any issues up until now.
Even a new database that I made just a week ago... Now when I attempt to change the sorting on a query I get the error "Record is deleted" and it doesn't allow me to save the changes. Upon re-opening the database I get "Property not found" and all my forms got deleted.
I haven't properly tested this but I think if I save the ACCDB locally on my drive the DB will retain its consistency but why now all of a sudden it's going corrupt on a network drive? I don't experience any network connectivity issues so what could be causing it?