Problem in creating a MDE file

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

Guest

I try to convert my mdb to mde. After I have chosen the mdb and entered the Save As name, Access returns a message saying Access is unable to create a MDE database. I am using Office XP. Please advise.
 
Chris,

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.


hth,
--

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


Chris said:
I try to convert my mdb to mde. After I have chosen the mdb and entered
Click to expand...
the Save As name, Access returns a message saying Access is unable to create
a MDE database. I am using Office XP. Please advise.
 
Thanks. I found that I have omitted a library in the reference that caused the problem.
 
Back
Top