Cannot make MDE

[Guest]

Running Access 2003 on Windows XP Professional. Database has 2 forms (1 of
which is hidden), 88 queries (including Deletes and Appends), 3
converted-macro modules (and one VBA that I had some MVP help with!), and 6
tables (2 structure only).

VBA code is compiled, datbase is repaired and compacted. Performance is
analyzed and I have a few relationships that it's asking for (I am not truly
able to create these because these tables are created by the VBA code and the
queries - they aren't MEANT to relate to anything), and the recommendation
that I convert to MDE.

All that said, when I try to convert, I get the error message:

"The Visual Basic for Applications project in the database is corrupt". The
help dialogue says this:

This error can appear if you try to convert an Access 97 database to a more
recent Access database. If the database was not compacted prior to performing
this operation it is highly recommended that it be compacted as soon as
possible. Also, all macros and programs in the VBA projects associated with
the database should be compiled.
The database usually does not convert properly if the database is corrupt or
has many references to entries marked as deleted but not yet removed from the
database. Performing a compact and repair and then compiling it assures the
database is free of defects.
If necessary, you can import the data from the Access 97 database into a new
database using the File - Get External Data... - Import menu options of
Access.


Any other ideas as to why I am not able to make MDE?

Your help is graciously and gratefully appreciated,
Derek Wittman

 

[Jeff Boyce]

Derek

If the message is to be believed, the database was originally created in
Access '97.

If true, you may need to open it in '97, re-compile it in '97, the re-try
using '03.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Interesting theory. Unfortunately, I know of no installations of Access 97
in my company. I finally got a shiny new laptop with 2003 on it, and my old
one (I sent it back to our IS department for reimaging back about 3 weeks ago.

What's even more interesting (and I don't know if this matters) is that
there was no VBA code in the 97 --> 2000 versions. It was not until I pulled
it from the fileserver into Access 2003 that there was any VBA code (there
were, however, macros previously).

Thanks for your help, Jeff!
Derek

 

[Bill Mosca, MS Access MVP]

Derek

Something you might try...
Close the database but leave Access open. Click on Tools>Database
Utilities>Convert.

Convert the database to 2003 format. It MUST be in 2002-2003 format to make
an MDE with Acc 2003.

 

[Guest]

Still no dice, Bill.

Thanks for the suggestion.
Derek

 

[Bill Mosca, MS Access MVP]

Derek

ACK!

If it still won't create an MDE, it would appear that there is a syntax
error in your code or maybe in a macro.

I know you did mention that the code compiles. Maybe you have 2 procedures
with the same name?