Cannot Create MDE???

  • Thread starter Thread starter B. J. Betts
  • Start date Start date
B

B. J. Betts

This error is usually associated with compiling a large database into an MDE
file. Due to the method used to compile the database, a considerable number
of TableID references are created for each table. The Microsoft Jet
database engine version 4.0 can only create a maximum of 2048 open TableIDs
at one time. Exporting a database as an MDE potentially can exceed this
limit if the database has a large number of objects (table, macro, form,
report, etc).

My Access database file is 3 mb with little data ... why can't i make an mde
file?

Thanks
 
While what you say is true, number of objects is a distant second in
terms of frequency of being the reason for this. The most common reason
is a bug (or more) in the code. Open your VBA window (Alf+F11) and go
Debug > Compile [your database name]. This will highlight the first
error encountered in the code. Fix and repeat until no more errors are
found, then you should be able to produce your .mde.

HTH,
Nikos
 
Thanks Nicos... yes it does give some error messages during comipiling
specially with the acommand. Do i delete them?
 
During compilation ... there's an error ..
DoCmd.DoMenuItem acFormBar, editmenu, 8, , acMenuVer70
on the edit menu ... this button was created by wizard... why should it
cuase an error?
 
I wouldn't know! What is it supposed to do? Try to force the code to run
and see what error message you get.

Nikos
 
Back
Top