Tech Support Forums - TechIMO.com - View Single Post

ShuckyD · August 2nd, 2007, 11:22 AM

ive always been told that Access 97 databases break at the 1gb limit and have always been under that assumption. I usually use the built in feature in Access 97 to compact the database, but i have also used a utility called JetComp4 when Access is not available on a computer (Access 97)

http://www.mssqlcity.com/Articles/Co...QLvsAccess.htm

although it doenst say what the max amount of rows are that you can have in an Access 97 database, I'm curious to know

August 2nd, 2007, 11:22 AM	#3 (permalink)
ShuckyD Mobile Member Join Date: Apr 2005 Location: S. Central PA Posts: 3,601	ive always been told that Access 97 databases break at the 1gb limit and have always been under that assumption. I usually use the built in feature in Access 97 to compact the database, but i have also used a utility called JetComp4 when Access is not available on a computer (Access 97) http://www.mssqlcity.com/Articles/Co...QLvsAccess.htm although it doenst say what the max amount of rows are that you can have in an Access 97 database, I'm curious to know __________________ Thinkpad T61 14.1" wide \| WinXP Pro \| C2D T8300 CPU \| 3GB DDR2 \| 160GB HDD \| AGN & WWAN Lenovo S10 10.2" LED display \| 1.6Ghz Atom CPU \| 1GB DDR2 \| 1.3mp webcam \| B/G WiFi \| 160GB HDD Last edited by ShuckyD : August 2nd, 2007 at 11:31 AM.