We have an Access mdb database originally built in the late 90s. We currently use MS Access 2000 on Win7.
Since switching to win7 from XP the database keeps getting locked and corrupted and we are unable to open it. We then have to revert to backup copies made days before and lose lots of data. The database is around 36mb.
So does anyone know;
A) Is there any way to repair these locked/corrupted mdb files so we don’t lose data every time this happens.
And B) why this issue may be occurring in the first place. Are there known issues with office 2000 on win7?
So far google has failed to help me, hoping someone here may have some ideas!
Note due to the age of the DB we are unable to run it in any office version past 2000.