Creating ACCDE file

Question

I have created a database consisting of 12 tables, 14 forms, 4 queries, 12 reports, 2 modules.

Each form contains minimal VBA code.

I have split the database successfully.

When creating a .ACCDE file the program aborts with the message:

Microsoft Access was unable to create the .accde, .mde or .ade file

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.

What am I doing wrong?

Answer 1

Hi Sanlogent,

 I have seen this error happen when there are issues with the code in the database.  If you open the database and go into the VBA window are you able to compile the database without a problem (debug menu -> compile)?  If you run into errors compiling the database this way, fix these errors and then once you can successfully compile the file this way then try creating the ACCDE file again.

Best Regards,

Nathan O.

Microsoft Online Community Support

Answer 2

Hi Sanlogent,

 I have seen this error happen when there are issues with the code in the database.  If you open the database and go into the VBA window are you able to compile the database without a problem (debug menu -> compile)?  If you run into errors compiling the database this way, fix these errors and then once you can successfully compile the file this way then try creating the ACCDE file again.

Best Regards,

Nathan O.

Microsoft Online Community Support

thanks it was really helping but i can't resolve my VBN compile error 

Sub, Function, or Property not defined (Error 35)

Answer 3

I did as you suggested and the issue was resolved. 

Thank you very much.

Answer 4

Luke

Thanks for that info. One more reason to stay away from the 64-bit version.

Answer 5

We're seeing situations where this is failing with Access 2010, 64-bit version that have nothing to do with the compile state.