Can't compile my DB keep getting error

[Emily]

This must be something simple to solve, but I just couldn't figure it out !!
Can anyone help! I just wanted to compile a simple DB contains 5 tables, 5 queries, 5 forms and 2 reports. When I tried to make a .accbe on my access 2010 I got the following message.

" 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. "

Any suggestions! thanks in advance!

 

[boblarson]

Just open the VBA window, go to DEBUG > COMPILE and then it should take you to the first error (highlighting it in Yellow) and then you fix that error, go back and do it again until there are no more errors. Then you can create your ACCDE file.

 

[Emily]

Thanks Bob I followed your instructions and I got it to compile now. Thanks.

By the way, should we be compiling? It seems to me the compiled version only limits the user not to edit or change forms and reports only. Am I correct?