D
Deano
Everytime I try to convert my database to an MDE I get the following message
"Microsoft Access in unable to create an MDE Database" and when I press the
Show Help button I get this displayed.
"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."
I am using Access XP(2003) and the database has 33 tables, 49 forms and 3
modules. I have even created a new databse and inported 10 tables and 2
forms and I still get the same message. Can anyone help
Thanks in Advance
"Microsoft Access in unable to create an MDE Database" and when I press the
Show Help button I get this displayed.
"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."
I am using Access XP(2003) and the database has 33 tables, 49 forms and 3
modules. I have even created a new databse and inported 10 tables and 2
forms and I still get the same message. Can anyone help
Thanks in Advance