Fix for Access MDE Create Failure

Microsoft Office Access was unable to create an MDE database: "Re: Microsoft Office Access was unable to create an MDE databasehttp://www.blogger.com/img/gl.link.gif
http://www.blogger.com/img/gl.link.gif

It is a bit tedious but it worked for me and it might work for you…
-You have to start in the same Office version as the one that it was created in, or converted into
-Open your database (the one you want to convert to ‘.mde’), using the bypass key (shift)
-Open the VB Editor and choose from the menu: Debug – Compile . Correct all the bugs in your code (if any), close VB Editor.
-Run the ‘Compact and repair database’ utility, and close the database
-Create a shortcut to your database on your desktop. In the target of the shortcut type in after the database path the switch: /decompile
-Open the database using the shortcut and convert your database to .mde

Good luck… ;-) "