MDE encrypter 2048 Table IDs limitation

  • Thread starter Thread starter FreeWheel
  • Start date Start date
F

FreeWheel

Hi,

My application holds many tables and very many queries, reports and forms...
JET will not compile because of too many Table ID references (over 2048).

How do I get around this ?

Tks
 
FreeWheel said:
My application holds many tables and very many queries, reports and forms...
JET will not compile because of too many Table ID references (over 2048).
Click to expand...

The only way around this is to reduce the number of objects.
Possibly split up your MDB into two by function.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
On Sat, 18 Oct 2008 11:14:01 -0700, FreeWheel

Export everything to a fresh database and try again.
If that does not help, you may have exceeded the Access design
specifications, and you should be looking for a different DBMS.

-Tom.
Microsoft Access MVP
 
Import everything into a new database (to remove
any dead object count).

If that doesn't work, break the database into a couple
of library databases, and reference them from a shell
database.

(david)
 
Chris O'C via AccessMonster.com said:
Are you sure that's really the problem? The help gives that excuse when the
mdb can't be converted into an mde for *any* reason. That's when the code
isn't compiled, the db format isn't in the current version of Access, missing
activex controls, missing libraries, reference libraries in mdb format, etc.

Rule out the common mistakes which prevent conversion to mdes before you
assume there aren't enough table ids. You'll probably save yourself a lot of
unnecessary work.
Click to expand...

Geez, I keep forgetting that can be the cause of this message.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Chris O'C via AccessMonster.com said:
After reading your other posts, I see you have a vba password set. Remove
the vba password before trying to convert to mde, because that prevents
conversion.

Chris
Microsoft MVP
Click to expand...

Hm, in Access 2003, I am able to compile a database to an mde even though
there is a VBA password.

- Steve
 
Back
Top