Unable to create an MDE database

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

Guest

I receive an error message when trying to create an MDE file from a Database which was created in MS Access 2000 using MS Office Developer 2000 version 1.5
The data base was created on the same computer using the same software
The message state: Microsoft Access was unable to create an MDE database. The only option I have is to press the OK button
Anyone knows what the problem could be? MY Access is Access 2000 9.0.6926 SP-

Thank yo
 
You have to password protect the code before Access lets
you create an MDE. Get into the code and select Tools_
Properties and select the protection tab. Once you create
a password you should be able to create the MDE. You also
need to make sure the code will debug with no hickups.


-----Original Message-----
I receive an error message when trying to create an MDE
Click to expand...
file from a Database which was created in MS Access 2000
using MS Office Developer 2000 version 1.5.
The data base was created on the same computer using the same software.
The message state: Microsoft Access was unable to create
Click to expand...
an MDE database. The only option I have is to press the OK
button.
 
No. You do *not* have to password protect your database in order to create
an MDE.

The most likely reason for this failure is: 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.


--

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


MDE said:
I receive an error message when trying to create an MDE file from a
Click to expand...
Database which was created in MS Access 2000 using MS Office Developer 2000
version 1.5.
The data base was created on the same computer using the same software.
The message state: Microsoft Access was unable to create an MDE database.
Click to expand...
The only option I have is to press the OK button.
 
MDE said:
I receive an error message when trying to create an MDE file from a Database which was created in MS Access 2000 using MS Office Developer 2000 version 1.5.
The data base was created on the same computer using the same software.
The message state: Microsoft Access was unable to create an MDE database. The only option I have is to press the OK button.
Anyone knows what the problem could be? MY Access is Access 2000 9.0.6926 SP-3

Thank you
Click to expand...
Open any standard module and compile your program.
"Debug/Compile and save all modules"
You have an error in the code that will not compile.
This is why Access will not create an MDE for you.

Ron
 
Database which was created in MS Access 2000 using MS Office Developer 2000
version 1.5.
Open any standard module and compile your program.
"Debug/Compile and save all modules"
You have an error in the code that will not compile.
This is why Access will not create an MDE for you.
Click to expand...

Maybe, maybe not!

Another cause of MDEs not creating, is the use of methods of the dbengine
object not being qualified explicitly with that object name. So, if the OP
uses OpenDatabase (for example), he should ensure that it says
DBEIGNE.OpenDatabase. Similarkly with all other methods of the dbengine
object. Otherwise, weird DAO licencing & other errors can occur, including
the inability to create an MDE.

HTH,
TC
 
Back
Top