Can't create an MDE database

[FollowTheSon]

I've been working with a database that has 5 linked tables and have been creating an MDE file from it with no problems. The other day I made soem changes and now it won't let me create the MDE file. The error says "Microsoft Access was unable to create an MDE dataabse." Any suggestions?

 

[thornmastr]

If you go to MSKB and search for “"Microsoft Access was unable to create an MDE database” you will get at least eight possible explanations.

Robert Berman

 

[gbowen]

Make sure you are not attempting to create the MDE on a network drive. Create it on a local drive.

 

[jerseyboy]

Try compiling your code. If there is a compile error it would also prevent it from working. You said that you made changes, perhaps you missed something in the code. The good news is that it will take your right to the problem if that is it. JerseyBoy
Remember: self-praise is no recommendation

 

[Dor100]

I've had much success with the things gerseyboy and gbowen mentioned. If your network drive account doesn't have much space left, it won't make the mde, but will on your C: drive. Clearing space on you network drive will help. Also, it is imperative that you have a back up copy of your db before you click Tools/Compile and Save All Modules in the Module window. It will walk you through each code error until all are corrected, but you have to keep doing it until you get no stoppages. Then, you trash the one you just compiled, and make the corrections in your original uncompiled copy that you're still working with.

 

[FollowTheSon]

ok, I tried creating it on my C: drive but to no avail. I was going to compile it but I don't see that option. Dor100 mentioned that it would be under the tools menu but I don't see it.

 

[Junior1544]

to compile it you need to get into a vb window... then in there click on the tools menu...

--James
JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[Castanz]

I had this problem right after I install SR1 (Service Release 1). My solution was to uninstall SR1. My .02$

Al

 

[FollowTheSon]

Ok, I got it working. Once I compiled, there was a reference that I was missing. After adding the reference then I was able to compile and then make the MDE database. Thanks to all for your help!

Follow The Son! Matt. 16:24-27