Can't create MDE!

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

Guest

Hi,
I'm very confused. I created some MDE files this morning from five different small dbs. I didn't modify them (I think - I definitely know I didn't touch at least two of them). And now Access won't let me create MDE from them.
I tried creating a new blank database and importing everything. I also tried compacting.
What could my problem be? I'm using XP and Access 2003.
Thanks.
 
audreybmorin said:
Hi,
I'm very confused. I created some MDE files this morning from five
different small dbs. I didn't modify them (I think - I definitely
know I didn't touch at least two of them). And now Access won't let
me create MDE from them. I tried creating a new blank database and
importing everything. I also tried compacting.
What could my problem be? I'm using XP and Access 2003.
Thanks.
Click to expand...

Make sure that (1) the files are in Access 2003 format, and (2) they
compile cleanly. If neither of those is the reason, I'm clueless.
 
The first thing to check, if making MDE fails, is to go to VBA editor and
click menu "Debug->Compile....database". Fix any code error found in
compiling. Although you claimed you did not touch the database since last
making MDE...well, it is worth doing a check.

audreybmorin said:
Hi,
I'm very confused. I created some MDE files this morning from five
Click to expand...
different small dbs. I didn't modify them (I think - I definitely know I
didn't touch at least two of them). And now Access won't let me create MDE
from them.
 
I compiled. Didn't give me any errors... I'm in the process of importing forms one at a time into a blank database. One form was crashing Access when I made MDEs, so I commented out every function and started adding one after the other to see which one crashed the program and... surprise! I ended up un-commenting everything and that form is now working. I'm really stumped.
 
I went back to my original file, commented out all the code, then reactivated each function in turn, testing creating a MDE between each step. I ended up reactivating the whole thing! I really don't get it.

Good news is, I can now create MDE files.

Bad news is, I have NO idea what went wrong, so there's no way to prevent this happening again...
 
audreybmorin said:
I went back to my original file, commented out all the code, then
reactivated each function in turn, testing creating a MDE between
each step. I ended up reactivating the whole thing! I really don't
get it.

Good news is, I can now create MDE files.

Bad news is, I have NO idea what went wrong, so there's no way to
prevent this happening again...
Click to expand...

That's puzzling. My best guess would be some sort of corruption, which
your process corrected.
 
Back
Top