[AccessD] Backend database corruption

Tina,

Are you still working on this project? If not, then suggestions are
academic. If so, then the first thing to do is split the database! Put a
Front End on each client station and leave the BE where it is.

IMO, next thing to do is convert the BE to either SQL Express or MySQL.
Incidentally, a company called Bullzip <http://www.bullzip.com> offers a
pair of great tools that convert Access databases to either MS SQL or MySQL
-- and they are free. Once the database is converted, set up a new instance
of the FE that uses ODBC to connect to the new database.

Depending on the complexity of the Access BE, converting the FE to address
the new database can be trivial (where forms and reports are bound directly
to tables), or more involved (converting Select data sources to named
queries, which will arrive in the new BE as Views).

In the case of SQL Express, you'll need SSMS (the database manager) or SQL
Bench (the MySQL database manager).

While "graduating" to a real DBMS on the back end, you can leave the
current (split) database in place, until you get the new system working.
Splitting the old database will help significantly in preventing
corruption. And as previously mentioned, you have to replace the wi-fi with
wired connections.

Migrating the current DB to a real DBMS won't  take long, really.

Arthur
​