Can't make MDE

BobNTN

Registered User.
Local time
Yesterday, 19:47
Joined
Jan 23, 2008
Messages
314
All of a sudden, I can't make an mde file. No error messages just a blank grey screen with main menu at top. I have uninstalled and installed office numerous times, no luck. So I tried on an older db that I have never had trouble with, does the same thing.
Does make a db1.mdb file in the directory but .....
have let it sit for an hour, still does nothing else.
Tried both dbs on another pc with 2003, does the same.
Really weird.
Running Office 2003 SP2. xp on one pc and Win 7 on another.
Anyone got any ideas ?
 
Can you make an *.mde from a brand new empty *.mdb
 
Hadn't thought of that.
I just tried it and, yes, it did.
Where does that leave me ?
I can understand the new one might not but the older one I tried, I had made an mde a few months ago from it.

I have installed SP3 since I posted and uninstalled various programs based on info I got from Microsoft.com and nothing worked.
 
The first thing to do is enter a code module behind a form (any form with code) and run the “compile” routine on your database to see if you have any errors in your code, if you have any errors then fix them and try creating an *.mde again. Once you’ve done this if you are still having problems then the corruption may be somewhere else in your database.

When a database won’t convert into an *.mde it’s usually an indication that you have some corrupted code residing in the database. This is not necessarily the code you have written, but can be an old copy of it “stored within your database” by MS Access itself.

As I understand it, every time you make a change to your database MS Access keeps several revisions within itself, one of these revisions may well be corrupted or have some small corruption which is stopping the conversion process.

There are two methods you can use to remove this corruption, you can “de-compile” your database, there is much within this forum on how to do that, I suggest you do a search.

The other way is to create a brand new empty database and then copy all of the objects from your old database into the new database. I usually do both, the “belt and braces” approach, “de-compile” and “copy everything into a new database”.
 
Last edited:
The first thing to do is enter a code module behind a form (any form with code) and run the “compile” routine on your database to see if you have any errors in your code, if you have any errors then fix them and try creating an *.mde again. .

Can't quite figure how to do that from form properties. I don't have any modules in the db.

I did finally get it to build mde on the older db so you are correct that it apparently is in the new db. I have run analyzer as well as compact & repair.
 
sorry, I misstated.
Knew how to get there, just don't know how to compile from there.

I thought making an mde actually compiles the db ?

go to DEBUG > COMPILE <yourProjectNameHere>
 
Thanks Bob,
does exactly the same thing as 'Make MDE'
 
Try importing everything into a new, blank MDB file. And then try it again.
 
That worked
now, does it hurt to rename the db ?

and wonder why it did that ?
 
As always, THANKS for the help guys.

BTW, I notice when I run the analyzer, it has some suggestions of inserting 'Option Explicit statements'.

How important is this ? Seems to run ok without them.
 
Option Explicit should be in each module just under the Option Compare Database line. You can turn that on in the VBA window TOOLS > OPTIONS > Always Require Variable Declaration.

That way you have to declare your variables because if you don't, and the Option Explicit is not set, you can wind up thinking you're using one when it might be misspelled and then that is a big task sometimes to track those down.
 

Users who are viewing this thread

Back
Top Bottom