Access 2003 Password
Posted on 2006-10-19
The original file was something other thank Access 2003, but the computer is now operating the 2003 version.
Anyway, I need to get into a backend that has been secured. The person that did the securing doesn't know the password anymore...so...
I have access to the data, as this is just the backend, and the tables are linked to my frontend. The password is not a user level password, but rather the startup password. I tried some of the VBA solutions on here for Jet 3.0 or 3.5, and they returned incorrect strings, as was confirmed by creating a new database with a known password to test with.
I suppose if it comes down to it I will just copy the tables from the frontend into a new database, and start over, but that is a pain, and time consuming. All this just so I can add a primary key onto a table that should already have one!
PS> If there is any way to add that primary key without opening the backend database, that will suffice. High points due to difficulty and urgency.