cannot compile into MDE

[qwertyjjj]

I get the following error when trying to compile code int an MDE:
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.

There are only about 10 linked tables to SQL server, a decent amount of code but nothing that bad in the Access FE.
Any ideas on how to solve this?
As I understand it, the code will run faster when compiled?

 

[Zigzag]

I would start by decompileing the database and then compile followed by a compact and repair. Try making .mde after that.

Garry

 

[qwertyjjj]

no, doesn't seem to.
I decompiled by renaming then converted to 2002-2003 (from 2000).
Then repaired.
Then tried to make mde but same error.

?

 

[Zigzag]

I'm not familiar with the decompile method you mentioned.
I use the /decompile switch method.
It might be worth doing a search for it.

Garry

 

[qwertyjjj]

that worked

http://www.thescripts.com/forum/thread194636.html

What are the advantages to compiling on performance?

 

[Zigzag]

Glad to hear you have got it sorted.

As far as I am aware (and I'm probably wrong) is that if you compile, then access does not have to do this on the fly when it opens forms, runs code etc. once it is compiled it "should "stay that way. So not compiled initially you DB will run slower until all code is run, after that I dont think there is any difference.

Now I will sit back and wait to be ripped to pieces by the forum for being wrong.

Garry