Here's one for the vague files... I have a very simple Access XP (2002) MDB that I wish to turn into an MDE. I get this only error message: "Microsoft Access was unable to create an MDE database." That's it. No reasons why... nothing. The VBA code in the database's form compiles correctly (no errors in any controls). There are no linked tables. It's a very straightforward table/query/form/report MDB file. Any clues?

(I hate unhelpful error messages!) :(

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

All Micfoshaft Winblows error messages are useless!

Just because this happende to me. Is your MS Access 2002 opening a mdb file that was created with
Access 2000? maybe it is opening the file as Acess 2000.
Other than that try this.

_________________
-go to the Start menu
-select Run
-type in
         msaccess.exe /decompile

     This will open MS Access
-From the file menu select the file you wish to compile and open it
-go to a form that contains code and open it in design view
-open the code module
-go to the Debug menu
-Select compile
        if the file does not compile, fix or remove any bad code.
After the compile is done, save all the modules (clicking save once ussially is sufficient)
Save any forms if prompted.
Close Access, re-open the file and compact and repair

This will decrease absolutely all the empty spaces in your database front end.
___________



Sal

Sal, the MDB was originally created with Access '97 and converted into an Access XP (2002) format. When Access opens it, indeed, opens as a 2002 format.

Check... got this far. :)

That option is grayed out. D'OH!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The option gets grayed out right after a compile. You probably already did that.
Do this, open a form and make a change to the code. Then insert a blank line in between two lines of code. after you do that you no longer have a compiled database.

then try decompiling again.
Hope it works, make sure you do a backup before you decompile.

Sal

Sal,

Success! Thank you. :D


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division