D
Downie
issue:
Created 2000 MS Access Database
Converted APP and DATA to 2002-2003 versions each
1. App.mdb contains all queries, forms, etc.. and is linked to the
tables in the data.mdb
2. Removed all queres, forms, etc... from the data.mdb file.
In the App.mdb I tried to make .MDE file and I get the following
message;
Microsoft Office Access was unable to create and MDE database
Show Help >> button displays;
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.
More information about this error message online.
Can you help?
Created 2000 MS Access Database
Converted APP and DATA to 2002-2003 versions each
1. App.mdb contains all queries, forms, etc.. and is linked to the
tables in the data.mdb
2. Removed all queres, forms, etc... from the data.mdb file.
In the App.mdb I tried to make .MDE file and I get the following
message;
Microsoft Office Access was unable to create and MDE database
Show Help >> button displays;
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.
More information about this error message online.
Can you help?