VBA project "not viewable" in Access 2003 after upgrading from Access 2003 Beta

  • Thread starter Thread starter Tom McDonnell
  • Start date Start date
T

Tom McDonnell

I have an Access application, originally developed in
Access 2000 that was modified using Access 2003 public
Beta. Yesterday I upgraded to the release version of
Access 2003 and now I can not access the VBA code for my
forms and reports.

When switching to code view, I get a message box
titled "Project Locked" and a message of "Project not
viewable".

In hindsight I'm assuming there are differences in the
Beta and Release versions file format, but even converting
the application to 2002-2003 version file format does not
give me access to the code.

Can anyone help me?
 
I found KB article "823225 - "Project Is Unviewable" Error
Message While Opening a Visual Basic for Applications
Project in Microsoft Access" which appears to be similar
but following the steps of the workaround did NOT solve my
problem.

An additional note - I cannot view the VBA Project in
Access 2003 or Access 2000.
 
I found KB article "823225 - "Project Is Unviewable" Error
Message While Opening a Visual Basic for Applications
Project in Microsoft Access" which appears to be similar
but following the steps of the workaround did NOT solve my
problem.
Click to expand...

If you don't have a certificate, then try to decompile the project and see
if that helps.

Make a copy of the mdb and open the copy with the /decompile switch.

"C:\...\office11\msaccess.exe" /decompile "<path>\yourdb.mdb"

-- Dev
 
If you don't have a certificate, then try to decompile the project and see
if that helps.

Make a copy of the mdb and open the copy with the /decompile switch.

"C:\...\office11
Click to expand...
\msaccess.exe" /decompile said:
-- Dev
.
Click to expand...

I applied a certificate and now I can view the code in
Access 2003 - but not in Access 2000. I wouldn't typically
need to be able to view the code in Access 2000, but
ocassionaly it might be nice. Does anyone know how to
solve that issue?
 
I wouldn't typically
need to be able to view the code in Access 2000, but
ocassionaly it might be nice. Does anyone know how to
solve that issue?
Click to expand...

I don't think you can... Certificates are an Office 2003 thing, if I'm not
mistaken.

-- Dev
 
Back
Top