Access is unable to create a MDE

  • Thread starter Thread starter Ron Hinds
  • Start date Start date
R

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?
 
Ron Hinds said:
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?
Click to expand...


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?
 
Dirk Goldgar said:
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?
Click to expand...

Thanks Dirk! It was a compile error. Sure would be nice if Access gave a
simple error message like that!
 
Ron Hinds said:
Thanks Dirk! It was a compile error. Sure would be nice if Access gave a
simple error message like that!
Click to expand...

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

Tony
 
Ron Hinds said:
I'm getting this error when I try to compile my Access 2003 database FE.
Clicking show help gives this message:
Click to expand...

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

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

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

Why don't more people compile their code regularly?
 
Back
Top