By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,483 Members | 3,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,483 IT Pros & Developers. It's quick & easy.

Error when trying to Make ACCDE

P: 56
I am trying to generate a complied version of my Application by clicking on the "Make ACCDE" in Access 2007. It asks me where and with what file name to save the ACCDE however it quickly returns with an error "Microsoft Office Access was unable to create the .accde, .mde, or ade file"

It then displays a box with the following text..
"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 other way I can compile my application? - I don't really want to send out a copy of my application that can be readily accessed..
Sep 21 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494

I notice your edit comment says self-resolved. Can we take this to mean that this question is no longer outstanding?
Also, if you have a solution, would you have the time sometime to post it in here in case someone with a similar problem finds this thread.

Best regards -NeoPa.
Oct 6 '07 #2

P: 68
Since I did not see solution for this years old post when searching this forum, I thought my finding may save others time if this occur.

I had same message when trying to create accde file in Access 2010 32 bit version. I found this link and the solution solved my problem - An Vba bug caused the issue in my case. debug solved the problem.

below is the link.
Aug 22 '13 #3

Expert Mod 5K+
P: 5,397
Joe Y,
That's some valuable information right there!!!

Because I do not trust the life of the link, I've transfered the answer given in link below. Of note within the referenced thread is the error is also showing up in the 64bit install versions for the same or related bug:

Creating ACCDE file fails with error
Nathan O. - Microsoft Support replied on September 6, 2011

Microsoft Forum Moderator
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
Aug 22 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.