Access may stop responding when you try to create an MDE file or an ADE file (814858)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

SYMPTOMS

When you try to save an Access database file (.mdb) as an MDE file (.mde), or when you try to save an Access project file (.adp) as an ADE (.ade) file, Access may stop responding. You may receive the following error message:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
Please tell Microsoft about this problem.
We have created an error report that you can send to help us improve Microsoft Access. We will treat this report as confidential and anonymous.
To see what data this error report contains, click here.

If you click the link for To see what data this error report contains, click here, you may receive the following error signature:
AppName: msaccess.exe AppVer: 10.0.3409.0 ModName: mso.dll ModVer: 10.0.3501.0 Offset: 0001c4c5

Additionally, other offsets, other versions of Access, and other versions of the mso.dll are possible.

CAUSE

This problem may occur when the compiled Visual Basic for Applications (VBA) project of the .mdb file or the .adp file is corrupted.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

WORKAROUND

To work around this problem, you can reload the VBA project of the Access database from text and then create the MDE file or the ADE file. To do this, follow these steps:

Note Make a backup copy of the database before you start these steps.
  1. On the taskbar, click start and then click Run.
  2. Type <Microsoft_Access_Path>\msaccess.exe /decompile and then click OK.

    Note <Microsoft_Access_Path> is the path of the folder where Access is installed.
  3. Open the original .mdb file or the original .adp file that you want to save as the new MDE file or the new ADE file.
    1. Press ALT+F11 to open the Visual Basic Editor.
    2. On the Debug menu, click Compile <DatabaseName>.
    3. On the File menu click Save <DatabaseName>, and then close the Visual Basic Editor.
  4. On the Tools menu, click Database Utilities and then click Make MDE File or click Make ADE File.
  5. In the Save MDE As dialog box or the Save ADE As dialog box, locate the folder where you want to save the MDE file or the ADE file, type the file name in the File name box, and then click Save.

REFERENCES

For more information about MDE files, click Microsoft Access Help on the Help menu, type mde in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned. For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

278376 ACC2002: "Make MDE File" or "Make ADE File" Command Is Not Available

289686 ACC2002: Error Message: "Microsoft Access Was Unable to Create an MDE Database"

Modification Type:MajorLast Reviewed:12/14/2004
Keywords:kbstoprespond kberrmsg kbBug kbnofix KB814858 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.