Error with creating MDE File

J

JR619

I have changed a form in my MDB database and am now attempting to create an
MDE database. However when I choose this option the message comes up stating
"Microsoft Access was unable to create an MDE database." I am unsure where
to look to find out why this is occuring. Or what other information is needed
to find out the cause of this message.

Thank you for any help with this!!
 
J

John Vinson

I have changed a form in my MDB database and am now attempting to create an
MDE database. However when I choose this option the message comes up stating
"Microsoft Access was unable to create an MDE database." I am unsure where
to look to find out why this is occuring. Or what other information is needed
to find out the cause of this message.

Thank you for any help with this!!
Click to expand...

There are a couple of possibilities here:

1. You can only create a MDE if the database format matches the
version of Access you are using. Access XP and 2003 default to using
the Access2000 format; but you must use Tools... Convert to convert
the database to XP or 2003 format prior to creating a MDE.

2. There must NOT be any compile errors. Type Ctrl-G to open the VBA
editor and select Debug... Compile <your databse>. If there are any
compile errors, correct them, and repeat until they're all fixed. Then
select Debug... Compile for the last time, close VBA, and compact
again. THEN try the MDE conversion.


John W. Vinson[MVP]
 
J

JR619

Thank you very much for all the help!!

John Vinson said:
There are a couple of possibilities here:

1. You can only create a MDE if the database format matches the
version of Access you are using. Access XP and 2003 default to using
the Access2000 format; but you must use Tools... Convert to convert
the database to XP or 2003 format prior to creating a MDE.

2. There must NOT be any compile errors. Type Ctrl-G to open the VBA
editor and select Debug... Compile <your databse>. If there are any
compile errors, correct them, and repeat until they're all fixed. Then
select Debug... Compile for the last time, close VBA, and compact
again. THEN try the MDE conversion.


John W. Vinson[MVP]
Click to expand...
 
Top