I have a Access 97 database that I am trying to open up but I can't. The reason why is because it asks for a password as soon as the database starts to open. I created a new database and tryed to import the tables from the database that I can't get into but I still get prompted for a password.
Does anyone have an idea on how to get into teh database or a workaround?
I seem to remember reading that with Excel 97 you could create a normal file and a password protected version of the same file and compare the hex code at the beginning of each file. The difference would give you the location of the encoded password. I guess then you could paste the relevant hex for an unprotected file into any protected file and you would have effectively erased the password protect. This presumably works because only the password was encrypted and not the whole file (unlike the more sophisticated methods of later versions). I have no idea if this works or if it would work on an Access file (or even if I'm talking about the right version for that matter ). If you are going to attempt this make sure you have backup files.
There are loads of password crackers available on the web for MS Office products although I suspect most will charge. You might find you can run a trial version that will give you say the first 4 characters of your password which will remind you what it was (?).
You can also pay a third party to crack your file. Again, there are many of these available on the web.