Access Maximum records

G

Guest

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

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".
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top