Creating MDE File Unsuccessful

[Tony]

G'day

My attempt to create an MDE file was unsuccessful. The attempt produced an
error that effectively said the (MDB) file was to big. The MDB consists of
about 30 tables, 50 forms and 3 Modules.

Have others encountered this problem and if so, have the found a work
around?

Tony

[Barry Young]

Hi Tony,

The best way to handle this situation is move the tables to a seperate
database and leave it as an MDB (via Import Export).

Then delete all the tables out of Main MDB. You then link to the tables in
the MDB you created (above).

Files Get External Data then Link Tables.. Specify the database .MDB file.

Then compile the Forms and Modules into an MDE and you should be fine.

The best practice is to keep the tables in a seperate database file or .MDB
file and then link to the tables in that database.

Hope this helps!

Barry
"Tony" <ri*********@hotmail.com> wrote in message
news:41********@news.comindico.com.au...

G'day

My attempt to create an MDE file was unsuccessful. The attempt produced an error that effectively said the (MDB) file was to big. The MDB consists of about 30 tables, 50 forms and 3 Modules.

Have others encountered this problem and if so, have the found a work
around?

Tony

[Tony Toews]

"Tony" <ri*********@hotmail.com> wrote:

My attempt to create an MDE file was unsuccessful. The attempt produced an
error that effectively said the (MDB) file was to big. The MDB consists of
about 30 tables, 50 forms and 3 Modules.

As Barry states you want to split your app.

What is the exact message? 50 forms and 3 modules is next to trivial. I have an
app with 450 forms, 350 reports and 20 or 30 modules.

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]

G'day Tony, Thanks for your reply. I have reperformed the operation and
reproduced the same error which reads as follows:

"Microsoft Office Access was unable to create an MDE database"

Clicking the help button on the error message box revealed the following ...

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

Because the message said the problem is "usually associated with compiling a
large database" I tried creating an MDE with a small database. The attempt
was successful and a MDE resulted.

Regarding your advice on splitting the database, I am aware of the benefits
of doing this, however on this occasion I preferred not to split as I want
to install a version on one only client machine as a test of the database.
By disableing "AllowbypassKeys" and delivering an MDE, I hoped to protect my
work from being copied.

I am working with Access 2003.

Thanks for your assistance.

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:0m********************************@4ax.com...

"Tony" <ri*********@hotmail.com> wrote:

My attempt to create an MDE file was unsuccessful. The attempt produced anerror that effectively said the (MDB) file was to big. The MDB consists ofabout 30 tables, 50 forms and 3 Modules.
As Barry states you want to split your app.

What is the exact message? 50 forms and 3 modules is next to trivial.

I have an app with 450 forms, 350 reports and 20 or 30 modules.

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]

G'day again. Further to the problem, even after splitting the database the
problem recurrs. I can create an MDE from the backend but it gives me the
same message when i attempt to create an MDE from the front end. Basically
it says that it is to big (when I am sure that it is not).

Is it possible that form templates, developed in earlier versions of acccss
and brought forward to Access 2003 for use could cause this problem (as this
is what I have done)?
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:0m********************************@4ax.com...

"Tony" <ri*********@hotmail.com> wrote:

My attempt to create an MDE file was unsuccessful. The attempt produced anerror that effectively said the (MDB) file was to big. The MDB consists ofabout 30 tables, 50 forms and 3 Modules.
As Barry states you want to split your app.

What is the exact message? 50 forms and 3 modules is next to trivial.

I have an app with 450 forms, 350 reports and 20 or 30 modules.

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