record limit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,

How many records can I have in ms access? what is the limit.
thanks
 
There is no limit to the number of records in a table.
The practical limit is that the database size cannot exceed 2GB.
 
hi,

How many records can I have in ms access? what is the limit.
thanks
Click to expand...

No specific limit, as Allen says; in practice, about the largest
production Access database table that I know of has some 20,000,000
records. Tens to hundreds of thousands of records are quite routine
and managable.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
what is the maxmun number of records in access 2003 1
Using the date on one form to limit the records from another table 5
Limit the size of an Access Table 1
Increase Record Limit in Auto Number 4
Limit on number of fields in MS Access forms 3
How can I limit Access query to 65000 records 4
Your dataplan 3

Back
Top