Error on making ACCDE

[hnhpak]

Dear All,


i have a problem in making my database to ACCDE following error message came.

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 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 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 TableIDs are used.

Do any one have solution for this I have a split database and want to change frontend to ACCDE.

[CJ_London]

The only way round the problem is to reduce the number of tableid's

500 forms is a lot - are many of these the same, but with slightly different functionality? e.g. same recordsource but showing different fields, or one for editing and one for adding new records? If so, consider combining these forms

Another thought is to split the front end into two or more based on who uses the system - you can still have a 'master' front end navigator to open different front ends

[Missinglinq]

The '500 Forms' mentioned is part of the standard error message from Access (which is what this entire explanation is) not the OP's comment or description of his database.

Error messages in Access are not noted for their accuracy, to say the least, and this message probably only means that the conversion failed. I'm willing to bet that you didn't Compile the file before attempting to convert it to ACCDE format; is that correct? If so, do a standard Compile, correct any problems that pop up, then try to convert it, again.

Linq ;0)>

[hnhpak]

Thanks Missinglinq, You are right, i had not compile the database, I am going to compile it and let you know the progress.

[hnhpak]

Thank you very much. You was right it is due to compile error in vbs code. After remove errors database published as accde and work perfectly.
Thank you once again.