Can't make MDE

[Emma]

I'm getting the following error message when I go to make mde:
This error is usually associated with compiling a large database into an MDE
file. Because of the method used to compile the database, a considerable
number of TableID references are created for each table. The Access database
engine 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).
There must be a way around this?

 

[Douglas J. Steele]

In addition to what Chris suggested, check the "Can't make an MDE!"
checklist at http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Emma]

Hi I recompiled the code and there was an error which I got rid of, but I
still can't make the mde. Was I suppose to create the BE first? Because we
have alot of records over 500 in some tables.

 

[Douglas J. Steele]

Well, there's no point having tables in MDEs, so yes, you should create the
BE first and only convert the FE into an MDE.