Misleading error message - "Microsoft Access Was Unable to Create an MDE Database"
Someone got this message using Access 2003 but this could also apply to other versions of access. Clicking help on the error message then displays
"This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 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 Jet 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 included the entire message so that folks searching on this message could find this blog posting.)
This posting sounds ominous but unless you have more than 1000 objects in your MDB/ACCDB you're not even close to having this problem. And that assumes that 1000 objects also have VBA code. So, for example, you'd have to have 100 tables, 300 queries and 700 forms and reports that also have VBA code.
The first thing to try is compiling the code to see if there are any errors. Ctrl+G to get to the VBA editor >> Debug >> Compile