Can't make accde

[slimjen1]

All, using Access 2010. I am trying to push a file into production. I have a split database and 50 users. It is giving me an error when trying to make an accde:

Microsoft Access was unable to create the .accde Help shows:

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.
Is there any one that can help me please?

 

[Ranman256]

it will work without being compiled.

 

[Minty]

If there are any un-fixed VBA errors it also won't compile.
Open the VBA editor window and select the compile option - it will highlight where the problem is.

 

[slimjen1]

Everything is complied without errors. I will grab a backup copy and start again and see what happens.

 

[Minty]

Just out of interest - I have dozens of tables , forms , queries on my databases and have never reached this compile limit? Has anyone else? Tables are linked however, if that makes a difference.

 

[AccessBlaster]

Maybe open a fresh new copy of Access and import everything, sometimes that fixes the little gremlins.

 

[slimjen1]

Got it. I created an copy and started from scratch. Thanks everyone