What is the capacity for an Access DB?

[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

 

[Peter Doering]

Jenny,

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?

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

HTH - Peter

 

[Daran Johnson]

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

 

[Brendan Reynolds \(MVP\)]

The answers are in the help file, Jenny, search for 'specifications'.