Converting MDE

D

Deano

Everytime I try to convert my database to an MDE I get the following message
"Microsoft Access in unable to create an MDE Database" and when I press the
Show Help button I get this displayed.

"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 am using Access XP(2003) and the database has 33 tables, 49 forms and 3
modules. I have even created a new databse and inported 10 tables and 2
forms and I still get the same message. Can anyone help

Thanks in Advance
 
J

Joan Wild

Deano said:
Everytime I try to convert my database to an MDE I get the following
message "Microsoft Access in unable to create an MDE Database" and
when I press the Show Help button I get this displayed.

I am using Access XP(2003) and the database has 33 tables, 49 forms
and 3 modules. I have even created a new databse and inported 10
tables and 2 forms and I still get the same message. Can anyone help

Access XP is 2002 not 2003. In both cases though, the default mdb format
used is 2000. In order to create an mde in 2002, the mdb must be in 2002
format. You can convert to 2002 via the Tools, Database Utilities,
Convert....

Then compile it, and then try to make the mde.
 
D

Deano

Sorry should've give a bit more info

The dbase is in 2002-2003 format and I am using Access 2003.
 
J

Joan Wild

Deano said:
Sorry should've give a bit more info

The dbase is in 2002-2003 format and I am using Access 2003.

Open any module or hit Ctrl-G and use Debug, Compile menu. That should show
you any errors you might have. Fix these and then try making the mde.
 
D

Deano

Thanks you very much that helped.

I'd spelt .value as .vlaue in some code. Surely Microsoft would've thought
about this somewhere and come up with a more descriptive error message
rather than point you to something completely different.

Anyway thanks again. Saved my bacon
 
D

Deano

Thanks you very much that helped.

I'd spelt .value as .vlaue in some code. Surely Microsoft would've thought
about this somewhere and come up with a more descriptive error message
rather than point you to something completely different.

Anyway thanks again. Saved my bacon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top