MDE files

[Daniel P]

I tried to create a MDE version of my database and I get the following error message with no details as to the actual reason

Microsoft Access was unable to create an MDE database

Does anyone know what is going on or how to resolve this problem

Daniel

 

[Cheryl Fischer]

Two possibilities come to mind:

1. There may be coding errors in the database; these will
prevent the creation of an MDE. Open any code module and, from the VBA
menu, select Debug, then Compile. If there are any errors, you will see an
error message and the problem line of code will be highlighted. Continue
compiling until the compile completes with no messages at all.

2. If you are using Access 2002 or 2003, the default database format is
Access 2000. Unfortunately, if you use the Access 2000 database format in
Access 2002/3, you cannot create an MDE. You may only create an MDE of an
Access 2000-format database using Access 2000.



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I tried to create a MDE version of my database and I get the following

error message with no details as to the actual reason.

 

[Patrick]

Hi Daniel!
Go to the VBA development window and slect from the menu:
DEBUG -> Compile
Correct any problems that The compiler finds.

This should get rid of the problem.

HTHs,
PAtrick

-----Original Message-----
I tried to create a MDE version of my database and I get

the following error message with no details as to the
actual reason.

 

[Daniel P]

Cheryl

Thank you for your help, I had an error when I compiled my code. Now everything is running smoothly

Daniel