Thread: When creating .accde it stops and fails

This is the Error I get:

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.

I deleted some tables and still can't get it to clear. Access 2007 btw.

Tables: 66
Queries: 85
Forms: 112 assuming they each have a modue double this number
Reports: 54
Modules: 14

Any thoughts are appreciated.

Thanks in advance,

Dan

Hi Dan,

Have you run the "Compact and Repair database" utility?

You probably already did that, but it's the only other way I know of reducing the TableIDs.

Cheers,

Originally Posted by ConneXionLost

Have you run the "Compact and Repair database" utility?

I have, I also combined and deleted a few queries. No luck so far. I will report back when I figure it out.

Thanks for the suggestion though

Dan

I figured it out. I got had by a child. One of the bosses kids had typed a bit on my keyboard when I was not at it. When I did the compile under debug, I found it.

In short if there is an error in your code it won't compile.(There were none except that. I had run it early but got distracted on the phone.)

Thanks,

Dan