When i try to create a .MDE file this is the error message i get.
"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."
The funny thing is i only have 9 forms, 14 tables and 1 module. I have tried exporting my forms into a new database but that does not help at all. Any ideas? My database is about 1.0Mb's zipped.
EDIT: i have narrowed it down to 1 form. when i delete this form i can make an .MDE file. Maybe it is just worth re making this form.
"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."
The funny thing is i only have 9 forms, 14 tables and 1 module. I have tried exporting my forms into a new database but that does not help at all. Any ideas? My database is about 1.0Mb's zipped.
EDIT: i have narrowed it down to 1 form. when i delete this form i can make an .MDE file. Maybe it is just worth re making this form.
Last edited:
