I used to be able to create an MDE file before I added some VB code to my
database. I now get the error message that "Microsoft Office Access was
unable to create an MDE database".
I removed the code and still get the same error.
Has anyone encounterred this in the past?
There are two necessities to make a .mde file in Access 2002 or 2003:
- The database must be converted to the same format as the version
you're using. AccessXP, for example, defaults to Access2000 format for
new databases; however, you must convert the database to Access2002
format in order to make a .mde.
- You must fix ALL compile errors before you can make a .mde file.
Type Ctrl-G to open the VBA editor and select Debug... Compile <your
database>. Fix any errors; compile again. Compact and Repair the
database and try again.
- You might need to Decompile the database if you've added and then
removed code. See the online help for the Decompile command-line
switch.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
