Paul Chernoff
Registered User.
- Local time
- Today, 12:49
- Joined
- Aug 24, 2018
- Messages
- 25
We have Access databases running with simple file sharing. The database files are on a Windows Server 2012R2. The clients are running Windows 10 under VMware. The Windows clients are only running Access, users have been warned not to run any other software. The data is in one file, most of the programming is in a 2nd and we have a 3rd file with additional programming for exports.
The data file is screwing up 2-3 times a day with 1-5 users at any time, usually just 2. When this happens I tell everyone to quit Access so I can open up the data file and allow it to repair itself. It is complaining about being out of sync. It repairs and the table that would hold references to any objects that have disappeared hasn't been formed. No one has noticed any damage but who knows. This last time the database shrunk from 75MB to 65MB, so that concerns me.
Any troubleshooting suggestions to make this database more stable? When we have time we will start writing an RFP and looking for someone to rewrite the database from scratch. The design is around 28 years old (was rewritten around 1999 in Access based on an Informix database (no design changes at all).
The data file is screwing up 2-3 times a day with 1-5 users at any time, usually just 2. When this happens I tell everyone to quit Access so I can open up the data file and allow it to repair itself. It is complaining about being out of sync. It repairs and the table that would hold references to any objects that have disappeared hasn't been formed. No one has noticed any damage but who knows. This last time the database shrunk from 75MB to 65MB, so that concerns me.
Any troubleshooting suggestions to make this database more stable? When we have time we will start writing an RFP and looking for someone to rewrite the database from scratch. The design is around 28 years old (was rewritten around 1999 in Access based on an Informix database (no design changes at all).