I can't generate one Module MDE in Access 2002,2003.

[Arturo]

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

 

[Tony Toews [MVP]]

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/

 

[boblarson]

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