|
 |
 |
 |
 |
Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
Trademarks
Article ID: 304548 - Last Review: April 7, 2006 - Revision: 7.0 You receive an error message when you try to view the code in a module, compile a database, create an MDE file or execute code in Access 2000This article was previously published under Q304548 Moderate: Requires basic macro, coding, and interoperability
skills.
This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp).
When you try to view the code for a module, try to compile
a database, try to create an MDE file, or try to execute code in a Microsoft
Access 2000 database, you may receive one of the following error messages:
Error accessing file. Network connection may have been
lost.
-or-
This action will reset the current code in
break mode. You may receive one of these error messages when both
Microsoft Access 2000 and version 6.3.91.8 of the Vbe6.dll file are installed
on the computer, and either of the following conditions is true:
- You imported forms or reports that contain code modules or
standalone modules into a new Microsoft Access 2000 database by using Microsoft
Access 2000.
- You copied and pasted forms or reports that contain code
modules or standalone modules into the Microsoft Access 2000 database by using
Microsoft Access 2000.
Then, you close and reopen the database and try to view,
execute, or compile the code.
If you have a computer without the version of Vbe6.dll that
is mentioned in the "Cause" section, you may be able to repair the problem with
the following steps:
- Open a form or a report in Design view.
- Save the code behind the form or the report as a text
file.
- Set the form or the HasModule property of the report to No, and then save the object.
- Repeat step 1 through step 3 for each form and report in
the database.
- Save each module as a text file.
- Create a new blank database.
- On the File menu, point to Get External Data, and then click Import. Import all tables, queries, forms, reports, data access pages,
and macros to the new database.
- Restore the code behind each form and each report from the
text files that you created in step 1 through step 4.
- Import each text file that you saved in step 5 as a new
module.
If you do not have a computer without the version of Vbe6.dll
mentioned in the "Cause" section, you must revert to a known good backup copy
of the database.
To prevent this problem from happening again, use one of the
following methods, depending on which version of Access you are
using. Using Access 2000Method 1 To prevent this problem from happening again, obtain
the latest service pack for Microsoft Office 2000. You must install this
service pack on all computers that run Office 2000.
For additional information, click the following article number to view the
article in the Microsoft Knowledge Base: 276367Â
(http://kbalertz.com/Feedback.aspx?kbNumber=276367/EN-US/
)
OFF2000: How to Obtain the Latest Office 2000 Service Pack
IMPORTANT: Before you install Microsoft Office 2000 Service Pack 3 (SP-3),
you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed
first. For additional information about how to obtain Office 2000
Service Release 1/1a (SR-1/SR-1a), click the following article number to view
the article in the Microsoft Knowledge Base: 245025Â
(http://kbalertz.com/Feedback.aspx?kbNumber=245025/
)
OFF2000: How to Obtain and Install the Microsoft Office 2000 SR-1/SR-1a Update
Method 2- When you import to a new database, create a new database
and import the objects into the new database. Or, when you copy objects in the
current database, copy and paste the objects into the current database.
- Before closing the database, open the Visual Basic Editor
by pressing ALT+F11.
- On the Debug menu, click Compile <database
name>.
- After you compile the database, close and save the
database. Note that when you reopen the database and view the code, the error
message that is mentioned in the "Symptoms" section of this article does not
occur.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
Some of the programs that include Vbe6.dll version 6.3.91.8
are Microsoft Office XP, its component applications, and Microsoft Visio 2002.
The version number of Vbe6.dll may also appear as 6.03.9180, depending on the
version of Windows that you are using.
Steps to Reproduce the Behavior- On a computer that has both Microsoft Access 2000 and
version 6.3.91.8 of the Vbe6.dll installed, open Microsoft Access
2000.
- In Microsoft Access 2000, create a new blank database and
name it ImportTest.mdb.
- On the File menu, point to Get External Data, and then click Import.
- Browse to the sample database Northwind.mdb for Microsoft
Access 2000.
- In the Import Objects dialog box, click the Modules tab.
- Click the Startup module, and then click OK.
- After successfully importing the Startup module, close the ImportTest database.
- In Microsoft Access 2000, open the ImportTest
database.
- Open the Startup module in Design view. Note that you
receive one of the error messages that is mentioned in the "Symptoms" section
of this article, and you are then unable to view the code for the Startup
module.
APPLIES TO- Microsoft Access 2000 Standard Edition
| kbqfe kbhotfixserver kbprogramming kbbug kberrmsg KB304548 |
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
|
 |
 |
 |
 |
 |
 |
 |
| |