Maximum number of Records

J

Jerry Kapchan

what is the maximum number of records a Access table can
handle?

thanks,

jerry
 
R

Rebecca Riordan

It doesn't have a record limit. It has a total database size limit. The
gory details are in an on-line help topic named "Access specifications".

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 

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

Similar Threads

Copy previous record into form field 0
Limit on number of fields in MS Access forms 3
Autonumber field in Excel that behaves the same as Access 0
sum based on value in a range 0
Maximum record size and maximum number of records 3
MS Project Overwrites Max. Resource hrs 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Wanted to get details of OWA logins 1

Top