Number a tables in access 2000 and 2002

  • Thread starter Thread starter mmadani
  • Start date Start date
M

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!
 
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.
 
Hi,
you can find out those table information/Access
Information by using Access Help file under

Access Specifications topic.

Jenny
 
Thank you fellow Texan ;-)
Cheryl Fischer said:
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.
Click to expand...
 
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?
 
Cheryl Fischer said:
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.
Click to expand...

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
 
Back
Top