Record limit

G

Guest

Is there a limit on number of records that can go into 1 microsoft access
database table?
 
J

Joseph Meehan

Ricky said:
Is there a limit on number of records that can go into 1 microsoft
access database table?
Click to expand...

No. There is a limit to the total size of the database. The older
versions could only be about 1 gig the newer ones will go to 2 gig. That
should allow over 1 million reasonable sized records.

I regularly worked with 200,000 - 500,000 records.
 
G

Guest

Ah ok...thanks a lot. Much appreciate. =)

Joseph Meehan said:
No. There is a limit to the total size of the database. The older
versions could only be about 1 gig the newer ones will go to 2 gig. That
should allow over 1 million reasonable sized records.

I regularly worked with 200,000 - 500,000 records.
Click to expand...
 

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

Record-Locking remains open after closing 0
AutoNumber Field Limits - NOT "How do I reset?" 11
How can I limit the number of records in a table, not a query? 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access limitations? 6
Number of Records 3
About Access limits 15
how to limit the record number 2

Top