convert to MDE file

R

RORO

hi! i have problem to make an MDE file for a data base.....
i always recieve this error...:"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."

thx for ur help...RORO
 
T

Tony Toews

RORO said:
hi! i have problem to make an MDE file for a data base.....
i always recieve this error...:

So just how many forms, reports and VBA modules does your MDB have?

Have you tried compacting the MDB first? Although I rather doubt that
would help.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top