So I have a split database. Front end is a .mdb file and backend is on a MySQL server.
Each user has a copy of the database saved locally. I have a local developer version that updates a "master" version stored on the network. The users' database then can update itself from that master version when need be.
However, the local copy on the users machine (not mine) has been getting (apparently) corrupted very quickly resulting in the given error.
All the articles I've seen say make a backup and to split your database and to ensure everyone is running a local copy. There is no data loss and the Master and developer versions of the DB remain uncorrupted.
I'm at a total loss as what to do. The user can edit data just fine until this corruption occurs and then needs to delete the local database and restore it with a copy of the master.
Any ideas? Even crazy ones...?
Thanks