What are the Access 2007 record table limits?

[billth]

For a previous project I tried SQL Server with an Access 2003 front end. The
low record table limits in Access 2003 froced me to steer away from it as my
project grew. I tried using MYSQL, but it lacked the stability I needed. I
will have 10-15 million records in any one table in this new project.

Can Access2007 handle this? If not any suggestions?

 

[Larry Linson]

I'm just wondering what specific "low record table limits" in Access 2003
you are talking about. A single table can be 2GB, less just a little
overhead. There is no specific record limit on tables in any version of
Access. If the 10 - 15 million records will amount to less than 2GB total
actual data, they can be handled in a single Access table. Because Microsoft
SQL Server is implemented with "multi-threading," you might find it to be
more responsive.

Larry Linson
Microsoft Office Access MVP

 

[Arvin Meyer [MVP]]

For a previous project I tried SQL Server with an Access 2003 front end.
The
low record table limits in Access 2003 froced me to steer away from it as
my
project grew. I tried using MYSQL, but it lacked the stability I needed.
I
will have 10-15 million records in any one table in this new project.

Can Access2007 handle this? If not any suggestions?

Not comfortably. For that many records and Access front-end is fine, but
you'll need a bigger database engine, like SQL-Server after you start
increasing beyond 500 MB. There is a 2 GB limit, but in practical terms even
half of that is too big.