error in making a mde file

W

william

Access 2003-error-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.
More information about this error message online.
 
R

ruralguy via AccessMonster.com

Start with Tools>Database Utilities...>Compact and Repair
or whatever ac2K3 has like that.
Then a /Decompile http://www.granite.ab.ca/access/decompile.htm
Compact and Repair again and then compile. Then Compact and Repair again.

Then try to make MDE again.

It is is still a problem then create a new/empty mdb and turn OFF Name
AutoCorrect.
Tools>Options>General tab
And turn ON Compact on Close while on that tab.
Close and open the new db
Import everything from the Old db and then close the new db. It only takes
seconds.
Now try to make MDE again. It must be in the ac2002-ac2003 format or it will
not make.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top