Does anyone know the Maximum size of an Access DB? Is there a limit to the amount of records that an Access table can hold?
Thanks,
Chris
Printable View
Does anyone know the Maximum size of an Access DB? Is there a limit to the amount of records that an Access table can hold?
Thanks,
Chris
No need for help.
I found out that it is about 1 Gig.
Chris
Just incase you needed confirmation, it is about a Gig for Access 95, possibly as well Access 97 but for 2000 I don't know. Access 1 was only 128Mb!!
regards
------------------
- Chris
[email protected]
If it ain't broke - don't fix it :)
In terms of the amount of records.... I have Access 2000 and added 2 millions (not kidding) to a table and it still worked fast and just fine... npw if you have more than 2 million records... I Hope it pays good money :)
Access95/97 - 1GB
Access2000/2002 - 2GB
I hate access now... i used to like it until it started crashing left and right when people over a network were accessing it... now it is SQL Server all the way baby!!
-