We have a client that has an Access Database they use for all of there client information. This was created many years ago in Microsoft Access 2003. 2 Years ago, we split the database to allow for multiple users, so there is now a front end and a back end database.
For 2 Years it was working fine, up until about a week ago. Now, pretty much every 2 hours, the database will go inconsistent. The only way to fix it is to compact and repair, which has a chance of removing some data from the back end database.
I require someone who is well versed in Microsoft Access Databases who can investigate the reason for the inconsistency issue and fix it.
There will also be an opportunity from our client for additional work once this initial problem is resolved.