Hi,
I nedd make a MDE file, en Tools_Data Base Utilities_Make MDE File, then
i have the window "Save MDE As"; in this moment i put the label with
extension ".mde" (Default.), i obtain the next message from Access:

________________________________
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.
___________________________
You can helpme to sayme that i have to do for make one MDE module, or one
method to have security my source code?

Thanks so much.

I'm sorry for my English.
Arturo Ruiz

Arturo <(E-Mail Removed)> wrote:

> I nedd make a MDE file, en Tools_Data Base Utilities_Make MDE File, then
>i have the window "Save MDE As"; in this moment i put the label with
>extension ".mde" (Default.), i obtain the next message from Access:
>
>________________________________
>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.
>___________________________
>You can helpme to sayme that i have to do for make one MDE module, or one
>method to have security my source code?

So how many tables, queries, forms, reports, macros and modules are in
your database?

Have you tried importing your objects into a new MDB and see if that
fixes the problem?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Make sure that the MDE file will compile too. Go to the code window and
select DEBUG > COMPILE and see if it generates any errors. An MDE file can't
be created if there are any compile errors.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________


"Arturo" wrote:

> Hi,
> I nedd make a MDE file, en Tools_Data Base Utilities_Make MDE File, then
> i have the window "Save MDE As"; in this moment i put the label with
> extension ".mde" (Default.), i obtain the next message from Access:
>
> ________________________________
> 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.
> ___________________________
> You can helpme to sayme that i have to do for make one MDE module, or one
> method to have security my source code?
>
> Thanks so much.
>
> I'm sorry for my English.
> Arturo Ruiz
>