Microsoft KB Archive/814858

= Access may stop responding when you try to create an MDE or ACCDE file, or an ADE file =

Article ID: 814858

Article Last Modified on 4/3/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb or .accdb) and a Microsoft Access project (.adp).





SYMPTOMS
When you try to save an Access database file (.mdb or .accdb) as an MDE file (.mde) or ACCDE file (.accde), 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 ACCDE file, or the ADE file. To do this, follow these steps:

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

Note  is the path of the folder where Access is installed. Open the original .mdb file, the original.accdb file, or the original .adp file that you want to save as the new MDE file, ACCDE file, or ADE file. To do this, follow these steps:  Press ALT+F11 to open the Visual Basic Editor.</li> On the Debug menu, click Compile .</li> On the File menu click Save , and then close the Visual Basic Editor.</li></ol> </li> In Microsoft Office Access 2003 or in earlier versions of Access, click Database Utilities on the Tools menu, and then click Make MDE File or click Make ADE File.

In Microsoft Office Access 2007, click the Database Tools tab, and then click Make ACCDE File or click Make ADE in the Database Tools group.</li> In the Save MDE As dialog box, in the Save As dialog box, or in the Save ADE As dialog box, locate the folder where you want to save the MDE, the ACCDE file, or the ADE file, type the file name in the File name box, and then click Save.</li></ol>

<div class="references_section">