how many lines of data can access handle in a table?

  • Thread starter Thread starter Guest
  • Start date Start date
Please feel free to post a complete question using the large blank space
provided.

The built-in help feature can tell you all the limits for your version of
Access. Simply go to "help" and type in "specification". Note that Access
does not have a limit to the number of records a table may contain. The
only real limit there is the overall size of the database file.
 
On Mon, 29 Jan 2007 14:46:01 -0800, Nette

No explicit limit - you can have up to two gigabytes in a single .mdb
file.

In practice, I've seen tables with 20,000,000 rows in production use.

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
VBA Multiple Line handling with Split() 1
How much data Access can handle? 25
Understanding Many-to-Many Relationship 4
How many lines can Access handle? 2
Import to many to many table 7
VBA Help in Access 2007 1
manually update field - want to create calc. but probl prev. table 3

Back
Top