MDE - Unable to create

[access2010]

I have tried to create an MDE database and receive the message
"Microsoft Access was unable to create an MDE database"

I deleted all unnecessary tables, queries, forms and reports and still receive this message.

Any suggestion on how to fix this problem in MsAccess 2003?

Thank you

Paul

 

[pr2-eugin]

Try a Compile of the Database, you will be pointed to some unhanded compiler errors (if any exists). Clear them (Then try creating an MDE).

(Not resolved? -) Try a Compact and Repair, then try the above step again.

(Not resolved? - ) Try a Decompile on a backup copy of the file; then perform the above two steps.

(Not Resolved? - ) Try importing all objects to a new empty MDB/ACCDB file then try creating an MDE from there.

 

[pbaldy]

The "usual suspect" is code that won't compile. In the VBA editor, run Debug/Compile and fix errors until it doesn't return any (it only reports the first error found).

 

[missinglinq]

And before you do anything, make and keep safe a backup copy of your file!

And just to be clear, this is a 2003 mdb file that you're trying to convert into an mde file, using Access 2003, correct?

Linq ;0)>

 

[access2010]

Thank you for your suggestions.

This worked, "Try importing all objects to a new empty MDB/ACCDB file then try creating an MDE from there".

 

[pr2-eugin]

Glad we could be of help. Good Luck !

 

[DemonDNF]

I'm using Access 2002 and also cannot create an MDE all of a sudden. I created my tables, set up relationships, and slowly started with Main Menu and one form at a time. I would make an MDE every once in a while and then save a copy.

I found the problem in my particular case; I copied one form, changed the table and set it all up nicely. BUT I forgot to delete the unwanted VBA code sitting in the background.

I deleted that and it can once again make a MDE.

Just in case it helps someone else.

Robert