cannot make MDE file

[Shift838]

I cannot make an access database in MDE format for some reason now. I updated some code and went to recompile and I get the below error. Of course Microsoft has nothing on it. I have repaired and compacted, ran in /decompile mode and nothing still the same. Any clues?

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.

 

[Darrylles]

Hi,

Your 'updated code' didn't involve creating an additional 'Module' file did it?

If so, then it sounds like you could have virtually doubled the number of tables required to create an .mde file (whether every form uses the new module or not).

If so, then copy the additional code from the new module to your old module, then delete the NEW module. This should reduce the number of tables by half.

Back-up your database app. before doing the above.

Regards,

Darrylle



Never argue with an idiot, he'll bring you down to his level - then beat you with experience. darrylles@yahoo.co.uk