Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Conversion / December 2005

Tip: Looking for answers? Try searching our database.

Error Compiling Large Database into MDE file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AccessDev - 19 Nov 2005 02:08 GMT
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 - 20 Nov 2005 19:56 GMT
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_Path>\msaccess.exe /decompile and then click OK.

Note <Microsoft_Access_Path> 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.

> I am getting this error message when I try to convert my Access 2003
> application into an MDE file. What can I do?
[quoted text clipped - 10 lines]
> database has 500 forms, and each form's HasModule property is set to Yes, as
> many as 1,000 TableIDs are used.
Ben - 29 Dec 2005 13:46 GMT
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
Signature

Novice

> Well, I didn't figure out what the problem was, but I did figure out how to
> fix it.
[quoted text clipped - 36 lines]
> > database has 500 forms, and each form's HasModule property is set to Yes, as
> > many as 1,000 TableIDs are used.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.