1) I am trying to make an ACCDE file from my existing development database and I am getting and error message stating it can't do it. When I select help from the little menu that appears this is the message.
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableID’s 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 TableID’s the access 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 TableID’s are used.
I have 26 tables, 20 queries, 44 forms and 14 reports. I am not trying to save it as MDE but ACCDE.
2) Is there a way for me to copy my entire database structure only without the test data in it to a new database. What I am looking for is to reset the autonumber id fields back to 0 and load with fresh data?
This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableID’s 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 TableID’s the access 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 TableID’s are used.
I have 26 tables, 20 queries, 44 forms and 14 reports. I am not trying to save it as MDE but ACCDE.
2) Is there a way for me to copy my entire database structure only without the test data in it to a new database. What I am looking for is to reset the autonumber id fields back to 0 and load with fresh data?
