Cant Create MDE

[Gulf Coast Electric]

I have a split database which is in 2000 format. I converted the front end
into 2002 format and tried to convert to mde, but it would not do it.
My version of Access is 2002 service pack 3 and original front and back end
are in 2000 format.
I still want the back end to be in 2000 format.
Any suggestions as to why I cant convert to mde?

 

[Rick Brandt]

I have a split database which is in 2000 format. I converted the front end
into 2002 format and tried to convert to mde, but it would not do it.
My version of Access is 2002 service pack 3 and original front and back end
are in 2000 format.
I still want the back end to be in 2000 format.
Any suggestions as to why I cant convert to mde?

Anything that would keep the full project from compiling will prevent the
creation of an MDE. Open a code window and then attempt to compile the
project. Anything that won't compile should be highlighted for you. Once
all of those are corrected you should be able to make an MDE.

 

[Cheryl Fischer]

In addition to making sure that the database file format is the same as the
Access version, you should also compile your application. 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.

 

[TC]

In addition to what the other respiondents have said, another possible cause
is VBA code that uses methods of the DBEngine object >without< explicitly
providing the DBEngine prefix. (For example, OpenDatabase instead of
DBEngine.OpenDatabase.) The code will compile ok, but it can cause causes
strange DAO licencing & other errors, including the inability tio create an
MDE.

HTH,
TC