|
Home > Archive > MS Access data conversion > December 2005 > Error Compiling Large Database into MDE file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error Compiling Large Database into MDE file
|
|
| AccessDev 2005-11-18, 8:25 pm |
| I am getting this error message when I try to convert my Access 2003
application into an MDE file. What can I do?
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.
| |
| AccessDev 2005-11-20, 8:24 pm |
| Well, I didn't figure out what the problem was, but I did figure out how to
fix it.
I decompiled the application file, then recompiled it and that fixed the
problem.
Here are the steps from the MSKB Article (814858) I found and thought I
would share in case anyone else runs into this problem:
Note Make a backup copy of the database before you start these steps.
1. On the taskbar, click start and then click Run.
2. Type < Microsoft_Access_Pat
h>\msaccess.exe /decompile and then click OK.
Note < Microsoft_Access_Pat
h> is the path of the folder where Access is
installed.
3. Open the original .mdb file or the original .adp file that you want to
save as the new MDE file or the new ADE file.
a. Press ALT+F11 to open the Visual Basic Editor.
b. On the Debug menu, click Compile <DatabaseName>.
c. On the File menu click Save <DatabaseName>, and then close the Visual
Basic Editor.
4. On the Tools menu, click Database Utilities and then click Make MDE File
or click Make ADE File.
5. In the Save MDE As dialog box or the Save ADE As dialog box, locate the
folder where you want to save the MDE file or the ADE file, type the file
name in the File name box, and then click Save.
"AccessDev" wrote:
> I am getting this error message when I try to convert my Access 2003
> application into an MDE file. What can I do?
>
> 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.
| |
|
| This is magical !
Thanks for posting your own problemsolving !!! I had the same problem and I
now can continue considering distributing my DB...
Thanks again,
Ben
--
Novice
"AccessDev" wrote:
[color=darkred]
> Well, I didn't figure out what the problem was, but I did figure out how to
> fix it.
> I decompiled the application file, then recompiled it and that fixed the
> problem.
> Here are the steps from the MSKB Article (814858) I found and thought I
> would share in case anyone else runs into this problem:
>
> Note Make a backup copy of the database before you start these steps.
> 1. On the taskbar, click start and then click Run.
> 2. Type < Microsoft_Access_Pat
h>\msaccess.exe /decompile and then click OK.
>
> Note < Microsoft_Access_Pat
h> is the path of the folder where Access is
> installed.
> 3. Open the original .mdb file or the original .adp file that you want to
> save as the new MDE file or the new ADE file.
> a. Press ALT+F11 to open the Visual Basic Editor.
> b. On the Debug menu, click Compile <DatabaseName>.
> c. On the File menu click Save <DatabaseName>, and then close the Visual
> Basic Editor.
>
> 4. On the Tools menu, click Database Utilities and then click Make MDE File
> or click Make ADE File.
> 5. In the Save MDE As dialog box or the Save ADE As dialog box, locate the
> folder where you want to save the MDE file or the ADE file, type the file
> name in the File name box, and then click Save.
>
>
> "AccessDev" wrote:
>
|
|
|
|
|