Microsoft Access was unable to create an MDE database

R

Ron Hinds

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).

I'm getting this in my Access 2003 database when I try to compile. I've
tried Compact, decompile to no avail. Any suggestions?
 

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

Unable to create MDE File 3
Access is unable to create a MDE 6
Can't make MDE 3
How to make the MDE file 3
Error encountered creating MDE in 2003 1
Problem saving Database as .accde format 11
Error when convert to MDE file 3
convert to MDE file 2

Top