Make MDE

[Zafar Salim]

Hi all!

I'm a first timer here...

While trying to make an MDE using access2003 this is the error i get :

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

The mdb has 84 forms and works perfectly as an mdb in Access2003. Making MDE
in Access97&2000 has not been a problem.

Would appreciate if someone can help.

Thanks
Zafar

 

[x-digital]

Oh guy, this is limition from ACCESS.
hehe

 

[Tony Toews]

While trying to make an MDE using access2003 this is the error i get :

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

The mdb has 84 forms and works perfectly as an mdb in Access2003. Making MDE
in Access97&2000 has not been a problem.

How many reports? Unless you have more than about 900 reports with
code <smile> this problem shouldn't be happening.

Are you up to date on the A2003 SPs? Try importing the MDB into a
new MDB.

Also this shouldn't make a difference but try doing a decompile.

Decompile or how to reduce Microsoft Access MDB/MDE size and decrease
start-up times
http://www.granite.ab.ca/access/decompile.htm

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

 

[Zafar Salim]

Hi,

I imported all the tables, queries, forms, reports and modules into another
mdb and then compiled it. Now it works fine.

Thanks for your help!

Zafar

 

[Tony Toews]

I imported all the tables, queries, forms, reports and modules into another
mdb and then compiled it. Now it works fine.

Glad that worked for you.

Thanks for your help!

You're quite welcome.

Thanks for posting back what worked. Helps us for the next people
with same 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