Create .accde file get error

When I click on the "Create ACCDE file" button I get the following error
(there a page to change the name, then click ok)

Microsoft office Access was unable to create the .accde, .mde or .ade file

with a SHOW button was says
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.

Do you know how to get around this error?
What I am trying to do is create the DB so a user can use it! How do I do
that and creating an .accde file is this the right way to do it??

Thanks
--
Regards

Richo

Richo <Richo.TakeThisOut@discussions.microsoft.com> wrote:

>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.
>
>Do you know how to get around this error?

That's a very misleading message. There is almost certainly a VBA
code error. Compile your project to locate any such errors. Ctrl+G
to get to the Immediate Window then Debug >> Compile.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/