This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile ...

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