How to unlock a read only database
Posted on 2004-10-14
A number of databases were created by an ex-employee. The employee's account has since been deleted. He created several MS Access applications that we now need to re-engineer or connect to from an external program (perl, but that is not relevent).
I can run the applications and use it to update the database etc.
I can open the applications, view the tables, forms etc, but only in read-only manner. Try as I may I cannot open the tables or forms to modify them.
I tried asking IT to give me an account with the same name as the ex-employee but that did not work. I asked an admin user to see if he could open the Access application and that did not work.
What do I have to do to gain read-write access to the MS Access applications?