Cannot create an MDE file

romio

Registered User.
Local time
Yesterday, 16:02
Joined
Apr 20, 2005
Messages
68
I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work.

This is what I got:
Code:
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.

So installed office XP and tried the same steps but still not working,
any help will be appreciated.

Thanks.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom