Maximum number of rows in one table of Access 2000

  • Thread starter Thread starter Manish Patel
  • Start date Start date
M

Manish Patel

Does anyone know what is the maximum number of rows that a
table in MS-Access database can hold? We are on Access
2000 and we need a table to contain 95000 rows.

However, we get an error when we try to upload more than
62249 rows in one table.

Any help is appreicated.

Regards,
Manish Patel
 
Hi Manish,

There's no specific limit, and tables with millions of rows are not
uncommon. There is however a limit of 2GB on the size of an Access 2000
(or later) mdb file.

How are you "uploading" the data and what error are you getting?
 

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

Max. # of rows in a worksheet 2
Access counts blank rows in Excel rows as records in linked table 1
Import Data from Excel - Size Limits 4
what is the maximum number of rows when exporting query to excel 3
Maximum Rows for a table 5
Question on the occupied field of the pivot table in excel spreadsheet 0
TransferDatabase ToSQL 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top