Cannot Create MDE???

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
 
N

Nikos Yannacopoulos

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
 
B

B. J. Betts

Thanks Nicos... yes it does give some error messages during comipiling
specially with the acommand. Do i delete them?
 
B

B. J. Betts

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?
 
N

Nikos Yannacopoulos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top