What is the capacity for an Access DB?

  • Thread starter Thread starter jenny
  • Start date Start date
J

jenny

Hi,

Is there anybody that can tell me what the capacity of
an Access DB is? Such as:

How many tables can a database have in Acess?
How big a table can be? or How many rows/columns can a
table have?
Or How big the Access DB can handle the maxium data size?
Is there a place that I can check to find out the access
capacity?

Thanks for all your help.
Jenny
 
Jenny,
Is there anybody that can tell me what the capacity of
an Access DB is? Such as:
Click to expand...
How many tables can a database have in Acess?
How big a table can be? or How many rows/columns can a
table have?
Or How big the Access DB can handle the maxium data size?
Is there a place that I can check to find out the access
capacity?
Click to expand...

A97:
<F1>Database specifications
A2002:
<F1>Access specifications

HTH - Peter
 
Jenny,

The limit in size of an Access database is approx. 2 GB.
The number of columns is 255.

What is it you are trying to accomplish?

Daran
 
Back
Top