Total Number of Records Allowed

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

Guest

In creating a database to track invoices, I have a large number of records.
Each invoice is 25+ lines, 400+ invoices per month. So, 10k line items per
month in a table. Each Excel worksheet can only hold 65k or so rows, so does
the database table hold a limited number of rows? Would it be any easier and
keep the database smaller if I link instead of import the records??

Thanks
Scott
 
There is no specific limit to the number of records that an ACCESS table can
contain. Instead, the limiting factor is the size of the entire .mdb file --
which is 2 GB for ACCESS 2000 and later versions.
 
Back
Top