Can't create MDE

[Guest]

I have a fairly large access database. I added some functionality which
requried me to add some procedures and when I create the .mde it hangs my
machine. I have gone through the steps on
http://www.Access.QBuilt.com/html/conversion.html
and everything checks out fine. I tried to create a new database and import
all the forms, tables, queries, etc and when I made the mde it said I reached
the maximum tableid limit of 2048. The fact that I could make the mde before
I made the changes makes me think I have reached the tableid limit. Once the
limit is reached what are my options? Are there ways to reduce the number of
tableids used?

 

[David Hodgkins]

Have you split the database so the tables are in one mdb file and everything
else in another mdb? You should then be able to create the mde from the mdb
with the forms, queries, etc, and then just link to the tables in the
database that hold the actual tables.

Hope this helps.

David Hodgkins, MCSD, MCDBA, MCSE
JSTAR Software Solutions
4402 Sweet Cherry Ln.
Kalamazoo, MI 49004
www.jstarsoftware.com - Home of AutoCompact for Access Databases
269-382-2931

 

[Guest]

Another reason to not be able to create an mde is because your code may have
an error. Make sure your code is compiled before creating an mde.

Unless you have an enormous database, I cannot image exceeding the table
limit. See if the compiling helps.

 

[Guest]

Yes the database is already split. Any other suggestions?

Thanks, Cori