MDE File

[MikeS]

I'm trying to make an MDE file from a program I have written, but I get the
message "Microsoft Access was unable to create an MDE database". When I
click on "Show Help", I get the following explanation:

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

Does this have anything to do with the fact that I have links to external
databases? I'm not sure what it means by "open TableIDs". I only have 8
tables (all linked), 10 queries, 5 forms, 14 reports and 1 macro for a total
of 38 objects.

Thanks in advance for your help.

Mike

 

[George Nicholson]

Did you Compact & Repair before trying to create an MDE?

In addition, one of the following may help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;289686
http://support.microsoft.com/default.aspx?scid=kb;en-us;283788
http://support.microsoft.com/default.aspx?scid=kb;en-us;814858

If none of that helps, create a blank db, import all objects into it, etc. &
try again.

HTH,

 

[TC]

Forget all the TableID guff.

The most common cause of being unable to create an MDE file, is syntax
errors in the database. Use the Debug : Compile All option (or whatever
that is called in your version of Access) to recompile all the VBA code
in your database. You will probably find there is a syntax error. Fix
the error & repeat until there is no error. Then try the MDE again.

Another rare but possible cause of being unable to create an MDE, is
using methods of the dbengine object without explicitly using the
dbengine qualifier; for example:

opendatabase(..) instead of DBENGINE.opendatabase(..)

Check your VBA code for any of those.

HTH,
TC