Access 2003 hanging up when creating MDE files?

Question

Heya everyone. I'm trying to create an MDE file though access 2003.

There are 2 parts to this project. A front and a back end. Back end has the data and the relationships. The front end has the forms and will have the reports that I'm going to eventually create.

The front and back ends are connected by linking the two databases together.

When I try to create an MDE of the front end (via tools -> database utilities -> create an MDE), the status bar of access displays "Create an MDE/ADE file", Access completely hangs up, and it creates db1.mdb in the working directory.

The biggest pain is I was able to create the MDE about a week ago. Could it possibly be because of the way some forms are set up? Or do the Gods of Microsoft just hate me?

Answer 1

Try compacting and repairing it before creating the MDE.

If you have any VBA source code, you need to compile that as well.



You should also debug your source code to ensure there are no errors or corruption.



Once you've done that, try creating the MDE again.



If it STILL isn't working, try decompiling.

Go to Start > Run

Browse for MS Access' executable file (.exe)

Add /decompile at the end of it. It might look something like this:

"C:\Program Files\Office\MsAccess.exe" /decompile



After decompiling, open your database and compact and repair again. Then try to create your MDE.

Answer 2

Mde Files

Answer 3

First, I'd try a Compact and Repair from the Tools menu. If that doesn't help, go to Tools, Macro, Visual Basic Editor, then from the VB Debug menu, choose Compile and see if you get any errors. What changed since the last time you could make an MDE?

Answer 4

nice point (comment above), just seen the answers to the italy question, its just laziness, th ey get the answers and then forget about the people who provided them. unfortunaltey this happens quite often, all we can do is avoid helping these kind of people.