Project Unviewable

[Notace]

I have an Access database which I've been running for some time. Today
when I tried to get into the VB Editor, I got the "Project Locked -
Project is Unviewable" message. The DB is running under Access 2002 but
is in Access 2000 format.

I've found things that talk about removing certificates, signing the
project with a certificate etc, but can find no options to do this. I
can't open the project properties, as that just brings up the error
again. I'm at a loss.

This is my code! I wrote it! I've been tweaking it for a number of
years. How can I remove the lock on the project? (Prefer a free
method). To my recollection, I've never set a password or
(intentionally) locked this project.

thanks

 

['69 Camaro]

Hi.

I have an Access database which I've been running for some time. Today
when I tried to get into the VB Editor, I got the "Project Locked -
Project is Unviewable" message.

This can happen when:

1.) The file is an MDE database file; or
2.) The file has been digitally signed in Access 2003 or 2007 and the file
later opened in an earlier version of Access and the code is accessed; or
3.) The VBA project is corrupt.

I've found things that talk about removing certificates, signing the
project with a certificate etc, but can find no options to do this.

A digital signature can only be assigned or removed with Access 2003 or 2007.
If you believe someone digitally signed the file, you need to open the file in
Access 2003 or 2007 and follow the instructions on the following Web page:

http://support.microsoft.com/default.aspx?id=823225

How can I remove the lock on the project?

If it's an MDE, you can't. If it's due to a digital signature, follow the
instructions on the Web page I listed above. If it's due to corruption, you
can't remove the lock. There's no tool available to my knowledge.

(Prefer a free
method).

If the digital signature isn't the problem, then the simple, easy and free
method is to restore from backup. You do have a recent backup, don't you?

To my recollection, I've never set a password

If you did, the error message would be "Project Locked, Invalid Password," not
the one you're seeing.

or
(intentionally) locked this project.

You can't lock it without making it an MDE database file, so don't worry. That
doesn't happen accidentally.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.