MS Access data conversion - Problem creating an MDE

Author

Problem creating an MDE

Anand Vaidya

2006-02-02, 7:24 am

When I try to make an MDE of an MDB , I am getting the following error-
"Microsoft Office Access was unable to create an MDE database."
In ShowHelp >>
"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." - which is not relevant to my database as
it has only 5-6 forms.
The process for creating an MDE was-
Tools --> Database Utilities --> Make MDE File.
and Specify the folder and file name for the file and click the Save button.
I am left with no option .Any help would be appreciated.
Previously I could make an MDE for another application with out any problem.
Does Normalization in any way effect this process?I don't think so (not sure).

--------------------
Anand Vaidya
I'm here to know.

Joan Wild

2006-02-03, 8:24 pm

Open any module (or hit Ctrl-G). Then go to Debug, Compile.

That may highlight some errors in the code, which would prevent the creation
of the MDE.

Once you fix the errors, hit the save button and attempt the MDE again.

--
Joan Wild
Microsoft Access MVP

Anand Vaidya wrote:
> When I try to make an MDE of an MDB , I am getting the following
> error- "Microsoft Office Access was unable to create an MDE database."
> In ShowHelp >>

Douglas J. Steele

2006-02-03, 8:24 pm

And if that doesn't fix it, take a look at the "Can't make an MDE!"
checklist at http://www.access.qbuilt.com/html/c...l#CannotMakeMDE

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Joan Wild" <jwild@nospamtyenet.com> wrote in message
news:eM4iwnQKGHA.208@tk2msftngp13.phx.gbl...
> Open any module (or hit Ctrl-G). Then go to Debug, Compile.
>
> That may highlight some errors in the code, which would prevent the
> creation of the MDE.
>
> Once you fix the errors, hit the save button and attempt the MDE again.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Anand Vaidya wrote:
>
>
>

Sponsored Links