Record Limits

[J Speed]

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

J Speed

 

[Micah Chaney]

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

 

[Guest]

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]

many thanks

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