Can't make MDE

  • Thread starter Thread starter Emma
  • Start date Start date
E

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?
 
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.
 
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.
 
Back
Top