Making MDE File Problem

AlLeX_Brd

Registered User.
Local time
Today, 13:50
Joined
Jul 4, 2005
Messages
19
I,m trying to create mde file but a dreadful error mesage appeared :(

Here it is:

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

There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.


My database is not AS LARGE. It has 1 table, 36 queries and forms.
Any idea how this could be avoided?
 

Users who are viewing this thread

Back
Top Bottom