Total Number of Records Allowed

[scotikins]

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

 

[Ken Snell \(MVP\)]

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.