Tech Support Forums - TechIMO.com - View Single Post

U-96 · August 7th, 2007, 05:29 AM

Access 97 does have a 1GB limit - but this is per .mdb file and you can make a database with more than one .mdb file, which might offer a short term fix. There are no max rows AFAIK - it's the 1GB limit that will define that, depending on the depth and number of your tables.

You really should think about migrating to another solution though - even if it's a newer version of Access.

August 7th, 2007, 05:29 AM	#4 (permalink)
U-96 Ultimate Member Join Date: Oct 2001 Location: Silently running through the English Channel Posts: 1,439	Access 97 does have a 1GB limit - but this is per .mdb file and you can make a database with more than one .mdb file, which might offer a short term fix. There are no max rows AFAIK - it's the 1GB limit that will define that, depending on the depth and number of your tables. You really should think about migrating to another solution though - even if it's a newer version of Access.