Error message: Unable to create an MDE file

[johns88]

When I try to create an mde file from a 1.2 Gb access DB, I get the error message "Microsoft access is unable to create an MDE database".
The database has been compressed and repaired.
I'm running access 2000.
Any suggestions to fix this will be greatly appreciated.
thanks.

John

 

[nat1967]

Whoa!! 1.2 GB...thats a big 'ol database!!

You might try checking to see if there is a problem compiling the database. Thats usually the problem I have run into when that message appears.

If needed, the steps are:

GoTo VBEditor (alt-f11)>select debug from the toolbar>Compile

If there is an error in your code, the compiler will find it and show it to you in yellow. Fix that and run the compiler until no more errors. Then...try to create your mde again.

HTH

Have A Great Day!!!,

Nathan
Senior Test Lead

 

[johns88]

The database compiles fine.
It still won't create an MDE file.
Any other ideas?

 

[Hap007]

Nathan,

Four possible things to check.
First:
1) Open up a code window.
2) From the Menu select Tools>References
3) Make certain that there are no missing 'References'

Second:
If you are trying to make 1+ gig mde from a 1+ gig mdb, make sure you have at least 2+ gig free on the hard drive for the work file and the output file.

Third:
When Access runs low on Memory, during a compile, Access will save errors to a temp text file. If this is happening, examine the text file for further information.

Four:
You must have full access to the database. Besure that there are no objects that were created where you might not have full read, write access/ownership.

Hope This Helps,
Hap

Access Add-on developer

http://www.fcs-software.com

-