I’m trying to open an Access 2003 mdb file, but not having much luck.
Opening using Access 2003 in a Windows Server 2003 TS session.
It certainly seems to be genuinely an mdb file (not a re-extensioned mde), because once I get into the VBA environment, it’s possible to get a listing of all the Microsoft Office Access Class Objects corresponding to the various forms and reports in the database, along with the modules and class modules. I understand that being able to get a listing of this sort means that the file must be an mdb.
I’ve searched for a few function names (from an older version which I can get in to, and which are unlikely to have changed) in the file, opened as text, which takes me a somewhat mangled version of the code, so it’s still in there somewhere.
However, whenever I try to open any of the code in the VBA environment, I get a ‘Project is Unviewable’ error. I also don’t have the option to design any of the forms from within Access – only to open them.
The project does not have a digital signature, or appear to have ever had a password.
I’ve set all of the ‘Allow…’ properties of application.currentdb to true using the Immediate window.
Tools>References is ghosted, so I can’t do anything in there, although with some more VBA I’ve been able to check all the references (there’s 10 of them) and none of them claims to be broken (I’m also able to actually use the Access application, from an mde, on the same terminal server).
Using the Immediate window, I can look up the project in application.VBE.VBProjects.Item(1).Protection which indicates that the project is locked, but since that’s a read only property, I can’t just flip it and hope for the best.
I’ve tried everything I can think of and that the internet can suggest to get into this file, but I’m out of ideas.