Problem Creating MDE

[Janet95]

Hi Everyone,

I'm having a problem creating an MDE.

My database is 11mb in size and in 2002-2003 format.
It has 3 modules, 50 tables, 450 queries, 35 forms and 33 reports / subreports.
It is not a replica databas.
I have went to a form and opened the code and performed a compile project, that was successfull.

When I go to click on "Make MDE", I recieve the following Error Message:

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.
More information about this error message online.

I Click on the link in the error message and it say's

 Bulgarian Chinese (China) Chinese (Hong Kong SAR) Chinese (Taiwan) Croatian Czech Danish Dutch English Finnish French German Greek Hindi Hungarian Italian Japanese Korean Norweigian Polish Portuguese (Portugal) Romanian Russian Serbian Slovak Spanish Swedish Thai Turkish  
Details 
Product: Office 
Event ID: 10010 
Source: OfficeErrorMessages 
Version: 11.0 
Message: Links to additional information about the error message you saw are available below.

I am at a complete loss. I have tried the error message's suggestion to make all forms not associated with macros property value set to NO, however when I do that it says all code will be lost and it doesn't keep any code.

Any help and suggestion would be tremendously appreaciated.
Thank you so much in advance
Janet

 

[Janet95]

OK, I got it to work...
I forgot that I had a problem with a form so Imported one from a previous version and that form had some code for a txtbox that I deleted. So I went back to view code and complied it and it showed me where the problem was.

Now I'm ok it works just fine. My main problem was I just allowed myself to get frustrated with it and also lose sleep which made me for get that I imported the form after the first successful complie of code.

Thanks So much again
Janet