Project is Unviewable

10 May 2009 9:55 AM

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?

10 May 2009 11:45 AM

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 wrote:

>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.

--
Message posted via http://www.accessmonster.com

10 May 2009 3:40 PM

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.

Show quoteHide quote

"Barattolo_67" wrote:

> 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?

10 May 2009 5:24 PM

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 wrote:

>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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1

10 May 2009 5:49 PM

Barattolo_67

Thanks, will try.

Show quoteHide quote

"Chris O'C via AccessMonster.com" wrote:

> 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 wrote:
> >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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200905/1
>
>