Creeating Access MDE with ADE installed fails

[Guest]

I have received the following error after installing the ADE cd and trying to create a MDE of a db. The MDE process works with just one or two tables and two forms, but not with the small db I have created. I have 4 tables, 9 querys, 8 forms, 2 reports and 5 small macros. I consistently receive the error below. My jet 4.0 is version 4.0.8618.0, the link that comes up with the error indicates I should be at v82 or so

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

I can't believe that I cannot create a MDE from this db. The one table has 1263 rows of info with 76 fields, mostly short ones. The other table have 16 rows of 3 fields and another table has about 1000 rows of info with 6 fields per row.

I have updated the access db from 2000 to 2003, as well as creating and entirely new db in Access 2003, still the same results.

I'm stumped! Any suggestions would be greatly appreciated

TIA

Greg Mohr

 

[Elwin]

It's my understanding that the purpose of .mde format is
to protect the project from tampering, reduce file size,
optimize memory usage, and improve overall performance.
You CAN include tables in an .mde, but doesn't that kind
of defeat the purpose? I'd suggest splitting your
database to get the data out of there. I don't know if it
will solve the problem, but it's the main thing that
screams out to me. Good luck.

-----Original Message-----
I have received the following error after installing the

ADE cd and trying to create a MDE of a db. The MDE
process works with just one or two tables and two forms,
but not with the small db I have created. I have 4
tables, 9 querys, 8 forms, 2 reports and 5 small macros.
I consistently receive the error below. My jet 4.0 is
version 4.0.8618.0, the link that comes up with the error
indicates I should be at v82 or so.

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.

I can't believe that I cannot create a MDE from this db.

The one table has 1263 rows of info with 76 fields, mostly
short ones. The other table have 16 rows of 3 fields and
another table has about 1000 rows of info with 6 fields
per row.

I have updated the access db from 2000 to 2003, as well

as creating and entirely new db in Access 2003, still the
same results.