help with "MDE" 1

[Rolliee]

I have this in the forms forum and no one has been able to help. My database does not allow the Tools, DataBase Utilities Make mde option. It is greyed out. Any ideas anyone?


Rollie E

 

[jbehrne]

Rollie E,

Check your other thread,

jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[HenriM]

Try this:-

Open Access,
Tools-Database Utilities-Make MDE File
Follow the istructions.

You can give your new file the same name as the old as it won't overwrite; but be careful to select the right destination folder, otherwise you will have to search for your .mde file later.

One point, if there is the slighest error anywhere in your database you will get a message "Can't create .MDE File".

You can sort this by opening the .mdb file in design view, View - Code, Debug , Compile db1.

That will go right through your code and if there is an error, highlight it. Correct thr error, compile again and go on doing so until the database compiles.

Then go back to Access and make your .mde file.

Come to think of it, I have never tried the Database Utilities route; perhaps the reason for the greying out is an error in your code and sorting this would enable you to use Database Utilities.... I don't know.

Hope this sorts your problem.

Hope this works for you.

 

[Rolliee]

Henri,

jbehrne, suggested that I would have to convert to 2002 and that appears to correct the problem.

Thanks,

Rollie E

 

[Rolliee]

It still would not compile and I tried your "watch the compile." Voile' there was a STINKER in there. Once corrected and I have my mde. Thanks and here is a star.

Rollie

 

[HenriM]

Thanks for the star - I'll cherish it!

Just to tie up a loose end for other users. Because the .mde file is a file with all the code stripped out it is not possible to make it in any version other than that in which the original .mde was created.

For that reason, if disc space permits it is a good idea, when upgrading, to use the facility for leaving the
original Access Version intact. I never installed Office 2000 but when I upgraded my 97 to XP I left the Access97 in place. XP allows me to convert any of my files to 97,2000 or 2002, but if I want to make an .mde from the 2000.mdb I have to call in a chum who has 2000 on his machine.

Of course if you convert downwards you may lose some of the functionality of the higher version but so far the conversion has made any necessary changes for me and, - touch wood - it has not been a problem. The functionality tends to be in ease of input rather than fundamental structure and conversion does look after this.