Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 823225 - Last Review: June 8, 2004 - Revision: 2.3
You receive a "Project Is Unviewable" error message while opening a Visual Basic for Applications project in Microsoft Access
This
article applies only to a Microsoft Access database (.mdb).
Novice: Requires knowledge of the user interface on single-user
computers.
On This Page
SYMPTOMS
When you try to open a Microsoft Visual Basic for
Applications (VBA) project in Access 2000, and that project was created by
using Office Access 2003, you may receive the following error
message:
When you open the same VBA project by using
Office Access 2003, you receive a similar error message. The specified error
may occur even though the project is either digitally signed or is locked by
another user.
WORKAROUND
To work around the problem, follow these steps:
- Start Office Access 2003.
- Open the database that has the problem that was described
in the "Symptoms" section.
- Press ALT+F11 to switch to the
Microsoft Visual Basic Editor.
- Add a digital signature to the database. To do this, follow
these steps:
- On the Tools menu, click
Digital Signature.
- In the Digital Signature dialog box,
click Choose.
- In the Select Certificate dialog box,
select one of the available certificates, and then click
OK.
Note If the Select Certificate dialog box does not
contain any certificates, you can create your own certificate, and then perform
the previous steps. - In the Digital Signature dialog box,
click OK.
- Remove the digital signature from the VBA project. To do
this, follow these steps:
- On the Tools menu in the Visual Basic
Editor, click Digital Signature.
- In the Digital Signature dialog box,
click Remove.
- Click OK.
- Close the Visual Basic Editor, and then close
Access.
- Open the database again in Office Access 2003.
- Press ALT+F11 to switch to the
Visual Basic Editor.
- Close the Visual Basic Editor, and then close
Access.
Note Now if you open the database in Access 2000, you can open the VBA
project.
MORE INFORMATION
This problem occurs when you remove the digital signature
from the database that was created in Office Access 2003, and then you open the
database in Access 2000.
To avoid the problem, close the database
after you remove a digital signature from the database. You must reopen the
database in Office Access 2003 before you can open the database in any other
version of Access.
Steps to Reproduce the Problem
- Start Office Access 2003.
- Open the Northwind sample database in Access 2000 file
format.
- Press ALT+F11 to switch to the
Visual Basic Editor.
- Add a digital signature to the database. To do this, follow
these steps:
- On the Tools menu, click
Digital Signature.
- In the Digital Signature dialog box,
click Choose.
- In the Select Certificate dialog box,
select one of the available certificates, and then click
OK.
Note If the Select Certificate dialog box does not
contain any certificates, you can create your own certificate, and then perform
the previous steps. - In the Digital Signature dialog box,
click OK.
- Close the Visual Basic Editor, and then close
Access.
- Start Access 2000.
- Open the database as you did in step 2.
- Press ALT+F11 to open the Visual
Basic Editor.
- In Project Explorer, expand
Project.
Note You receive the following error message:
You expect this behavior
because the database is digitally signed. - Close the Visual Basic Editor, and then close
Access.
- Open the same database by using Office Access
2003.
Note When you try to open the database, you receive a security
warning. Click OK to open the database. - Press ALT+F11 to open the Visual
Basic Editor.
- Remove the digital signature from the VBA project. To do
this, follow these steps:
- On the Tools menu of the Visual Basic
Editor, click Digital Signature.
- In the Digital Signature dialog box,
click Remove.
- Click OK.
- Open the database by using Access 2000.
- Press ALT+F11 to open the Visual
Basic Editor, and then try to expand the project in Project Explorer.
Note Even though no digital signature is defined for the database, you
receive the error in the "Symptoms" section.
If you open the same
database in Office Access 2003, and then you try to open the VBA project, you
receive a similar error message.
REFERENCES
For additional information about how to create your own
digital signature, type
Create your own digital
certificate in the Office Assistant of Office Access 2003, and then
click
Search to view the topic.
APPLIES TO
- Microsoft Office Access 2003
- Microsoft Access 2000 Standard Edition
| kbvba kbprogramming kbprb kberrmsg KB823225 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please