Number a tables in access 2000 and 2002

[mmadani]

Hi there;

I was wondering if there is a maximum number of table you can have in either
one of these 2 versions
Thanks!

 

[Cheryl Fischer]

You are allowed a maximum of 32,768 objects in your database and the
database may not exceed 2 GB in total size. For additional specifications,
consult the Access Help file and enter "specifications" in the Answer
Wizard.

 

[Jenny]

Hi,
you can find out those table information/Access
Information by using Access Help file under

Access Specifications topic.

Jenny

 

[mmadani]

Thank you fellow Texan ;-)

You are allowed a maximum of 32,768 objects in your database and the
database may not exceed 2 GB in total size. For additional specifications,
consult the Access Help file and enter "specifications" in the Answer
Wizard.

 

[Cheryl Fischer]

You're welcom, Podnuh!

 

[mmadani]

Cheryl;

I think it is 2048 tables. 32,768 seemed a lot . Take a look I could be
wrong

M

 

[mmadani]

32,768 total (including forms, Macros, tables, etc...)

 

[Cheryl Fischer]

Checked Access 2002 again, and the spec is 32,768 *objects* which includes
tables. Are you possibly looking in the Tables specification which says
that you can have a maximum of 2048 *Open* Tables?

 

[Tony Toews]

You are allowed a maximum of 32,768 objects in your database and the
database may not exceed 2 GB in total size. For additional specifications,
consult the Access Help file and enter "specifications" in the Answer
Wizard.

Note that there is an unusual problem when creating MDEs.

ACC97: "Microsoft Access Was Unable to Create an MDE Database" Error
Message 177620
ACC2000: "Microsoft Access Was Unable to Create an MDE Database" Error
Message 202304

A97 allows a total of 1024 open TableIDs at a time, A2000 2048. Thus
if you have somewhere close, no definition of close, to 1024 objects
in A97 with code then you could run into troubles.

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