Error encountered creating MDE in 2003

[Dale Fye]

I've got a 2003 mdb application that I am trying to save as an MDE. But am
getting the following error message. This particular application links to
the backend at runtime, and there are only about 15 other tables in the
application. I consider this relatively small (25 forms, 10 reports, 100+
queries). I've tried compacted, decompled, recompiling, recompacted, but
that did not make any difference. I'm sure one of you guys has seen this
behavior before, and has work their way around this.

Microsoft Office Access was unable to create an MDE database.

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


--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Dale Fye]

FYI:

I was able to overcome this error message by creating a new database, and
importing all of the objects from my original into it.

Dale