convert to MDE file

[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

 

['69 Camaro]

Hi.

Check the "Can't make an MDE!" checklist on the following Web page to help
you determine why you can't create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Tony Toews]

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