Record Limits

J Speed · Feb 11, 2005

Does anyone know what is the maximum number of records you can have in a
single access 2003 table?

J Speed

Micah Chaney · Feb 11, 2005

In your Access help menu, do a search for "Access Specifications". It will
give you all the limits of Access.

Steve Huff · Feb 11, 2005

There is no maximum record number limit. Access 2003 datbases have a 2 gig
over all size limit though.

Here are some other specs:

http://www.microsoft-accesssolutions.co.uk/access_specifications.htm

-Steve Huff
null @ huffs.us

J Speed · Feb 11, 2005

many thanks

Micah Chaney said:
In your Access help menu, do a search for "Access Specifications". It
will give you all the limits of Access.