Project is Unviewable

[Barattolo_67]

I have converted an access database from Access 2003 to 2007 version, and
then I have deleted the old file (the one with .mdb extension). Now, in the
converted file I cannot see the code. When I try to edit the code, I get the
following error message:
Project Locked - Project is Unviewable.

I was suggested to digitally sign the file under Access 2003, and then
re-convert it to Access 2007. However, I cannot do that as I have deleted
the 2003 version of the file.

Any other suggestion?

 

[Chris O'C via AccessMonster.com]

You get that message when:

1 - the db is in mde or accde format.
2 - the db was digitally signed, the signature removed, then opened in a
version of Access earlier than 2003.
3 - the db file is corrupt.

Digitally signing the 2003 version and converting it to 2007 won't fix it.
Do you have a backup? Always make backups before you delete things you think
you don't need. Check your recycle bin. Might be in there if you don't
empty it often, like most of us.

Chris

 

[Barattolo_67]

Chris,

Thanks. Yes, the db is in accde format. I tried the following, and none of
them worked:
1) Compact/repair the database;
2) Exporting the objects inside the database and inside a new database.

As I do not have a backup, any suggestion would be appreciated to at least
recover the code.

Thank you.

 

[Chris O'C via AccessMonster.com]

Find the accdb file you made the accde file from. It has the code. Keep the
accdb file in a safe place. If you lose it, you're sol. You can't make
design changes to the accde file's forms and reports or change the code. You
have to do that with the accdb file and make a new accde file from it.

An accde or mde removes the canonical code from the project and prevents
design changes to forms and reports. The only things you can import into
another db file from accde or mde files are the tables, queries and macros.

Chris

 

[Barattolo_67]

Thanks, will try.

Find the accdb file you made the accde file from. It has the code. Keep the
accdb file in a safe place. If you lose it, you're sol. You can't make
design changes to the accde file's forms and reports or change the code. You
have to do that with the accdb file and make a new accde file from it.

An accde or mde removes the canonical code from the project and prevents
design changes to forms and reports. The only things you can import into
another db file from accde or mde files are the tables, queries and macros.

Chris