Accessing a mdb file

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.
EdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
Does the file open and function normally when opened on a local machine?
0
Jeffrey CoachmanMIS LiasonCommented:
Try the usual:
Create a backup

Run the compact/repair utility
...retry

Compile the vba code (in the vba editor, select: Debug-->Compile)
...retry

Decompile the entire db:
http://www.fmsinc.com/microsoftaccess/performance/decompile.asp

Create a new db and import all the objects
...retry

Lets see if other Experts can assist further...

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.