What is the maximum number of rows I can get in Access

#1

I have a need to get data going back to the 1800's, and need more than
100,000 rows. How many will Access hold, and what can I use that will
go over 100,000 records?

Thanks,

Bill

#2

"Bill" <billzimmerman (AT) gospellight (DOT) com> wrote

Quote:

I have a need to get data going back to the 1800's, and need more than
100,000 rows. How many will Access hold, and what can I use that will
go over 100,000 records?

Rows isn't relevant, size is.

Access 97 holds 1GB. Newer versions 2 GB.

If the total bytes per row is not large you should be fine. 100,000 rows is no big
deal for Access to handle.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What is the maximum number of rows I can get in Access

comp.databases.ms-access comp.databases.ms-access

What is the maximum number of rows I can get in Access - 08-05-2003 , 04:10 PM

Re: What is the maximum number of rows I can get in Access - 08-05-2003 , 04:25 PM