Access is unable to create a MDE

[Ron Hinds]

I'm getting this error when I try to compile my Access 2003 database FE.
Clicking show help gives this message:

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've tried Compact and decompiling followed by Compact again. I tried
deleting some tables and still no joy. Is there any other cause/solution to
this issue?

 

[Dirk Goldgar]

I'm getting this error when I try to compile my Access 2003 database FE.
Clicking show help gives this message:

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've tried Compact and decompiling followed by Compact again. I tried
deleting some tables and still no joy. Is there any other cause/solution
to this issue?

Do you think the message might be guessing right about the cause, or might
it be misleading? Would you say that your database has a particularly large
number of objects? If not, do you get any compile errors when you
explicitly compile your database using the Debug -> Compile menu item?

 

[Ron Hinds]

Do you think the message might be guessing right about the cause, or might
it be misleading? Would you say that your database has a particularly
large number of objects? If not, do you get any compile errors when you
explicitly compile your database using the Debug -> Compile menu item?

Thanks Dirk! It was a compile error. Sure would be nice if Access gave a
simple error message like that!

 

[Tony Toews [MVP]]

Thanks Dirk! It was a compile error. Sure would be nice if Access gave a
simple error message like that!

Yes, this message has been mentioned in the past as being misleading.

Tony

 

[Tony Toews [MVP]]

I'm getting this error when I try to compile my Access 2003 database FE.
Clicking show help gives this message:

Thanks for posting. I decided to blog about this message so folks
would have an easier time of coming across this message.

Tony

 

[David W. Fenton]

Thanks for posting. I decided to blog about this message so folks
would have an easier time of coming across this message.

I've never once had an issue creating an MDE because my code always
compiles.

Why don't more people compile their code regularly?

 

[o;;]

I've never once had an issue creating an MDE because my code always
compiles.

Why don't more people compile their code regularly?