Access Maximum records

K

Kathy Vander Vlist

Hi,
Can anyone tell me what is the maximum records you can have in access?
Thanks in advance
 
D

Dirk Goldgar

In
Kathy Vander Vlist said:
Hi,
Can anyone tell me what is the maximum records you can have in access?
Thanks in advance
Click to expand...

There is no maximum number of records. There's a maximum size to the
file, which is 2GB in Access 2000-2003. I'm not sure if that's changed
in Access 2007. Generally, information about limitations of the product
version you're using is available in the help file under
"specifications".
 
T

Tom Ventouris

The specs in 2007 appear to be the same as 2003.

Dirk Goldgar said:
In

There is no maximum number of records. There's a maximum size to the
file, which is 2GB in Access 2000-2003. I'm not sure if that's changed
in Access 2007. Generally, information about limitations of the product
version you're using is available in the help file under
"specifications".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Top