I have an Access DB, started it in Access 2000, then continued making modifications in Access 2003. I am trying to create an MDE file and it said I need to convert the DB to 2003 (apparently I didn't do that when I started in Access 2003. So I converted it. Then I tried to make an MDE file and it gave me the following error:
"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."
(There was no "more information about this error..." available)on that link.
The db only has 2 forms and 1 subform, 2 reports, 8 queries and 6 tables, but there is VBA code but I don't think it is that much.
Has anyone encountered this message? I am currently using MS Access 2003 (11.6566.8132) SP2.
Thank You!
"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."
(There was no "more information about this error..." available)on that link.
The db only has 2 forms and 1 subform, 2 reports, 8 queries and 6 tables, but there is VBA code but I don't think it is that much.
Has anyone encountered this message? I am currently using MS Access 2003 (11.6566.8132) SP2.
Thank You!
