Error when convert to MDE file

[Vensia]

Dear all,

What is the solution for below 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.

Thanks.
Vensia

 

['69 Camaro]

Hi, Vensia.

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]

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

That is a *lot* of objects. Do you really needs that many objects?

I'd suggest taking some functionality which is easy to separate out
and put into it's own MDB.

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

 

['69 Camaro]

Hi, Tony.

That is a *lot* of objects. Do you really needs that many objects?

For future reference, unlike earlier versions of Access which gave the
extremely unhelpful error message "Microsoft Access was unable to create an
MDE database" whenever conversion to an MDE database file failed, Access now
provides a "Show Help >>" button to display further extremely unhelpful
assistance whenever conversion to an MDE database file fails for any reason.

Selecting the "Show Help >>" button reveals the "Help" message that Vensia
copied verbatim into the post. If you bet money that the failure to convert
the file to an MDE database file had nothing to do with excessive TableID's
every time you saw this "Help" message, you'd win nearly 100% of your bets.

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.