Unable to compile MS Access2013 application

Question

      I need your help on compiling our MS Access2013 application.
The back-end database of this application is SQL database located in azure server. 
Here is my scenario:
I have received the following error message each time I attempted to compile this application:
“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.”

Answer 1

Hello,

The amount of info you supplied isn't enough to figure out the problem.

Could it be a compile issue (some error)?

Maybe https://support.microsoft.com/en-us/help/283788/access-microsoft-access-was-unable-to-create-an-mde-accde-or-ade-datab might help?

Cheers,

Andy

---

André Melancia | Developer / DBA / Microsoft Certified Trainer (MCT) | Andy.PT

Answer 2

9 out of 10 times, the error message is misleading.

BEFORE you attempt to create the accDE, simply in the vba editor go debug->compile.

The above will show you your compile errors. Fix those, and you have no issues creating the accDE file.

So for 99% of cases, you can ignore that misleading message.

The simple issue is your VBA code has compile errors. You want to fix those errors before you distribute. In fact during development, you likely uses debug->compile 50 or 100 times a day. Get in the habit of doing this so your VBA code does not “pile up” with a huge number of errors.

So it is a bad idea to try and run your application with compile errors. Simple get rid of all your VBA syntax errors, and ensure you can compile your code.

THEN and ONLY then should you attempt creating of an accDE.

Fix your compile errors as per above in the accDB. Once this is done, then the above “misleading” error message will go away and your be able to create the accDE without trouble.

It also rather un clear as to why you are creating a mde - for 2007 and beyond you should be creating a accDE - but fix any debug->compile error first. As noted, once done then creating the accDE should occur without issue. a "mde" goes back to access 2003 - that is 13 years old!

Regards,

Albert D. Kallal (Access MVP, 2003-2017)

Edmonton, Alberta Canada