Unable to create an MDE database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Go into the Vba part and Debug-> compile. If you get an error that is why you
couldn't create the .mde file.

HTH
Martin
 
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?
Click to expand...

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
 
Back
Top