Max Size of Access DB

[ChrisJackson]

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

[ChrisJackson]

No need for help.

I found out that it is about 1 Gig.

Chris

[chrisjk]

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
chris.kilhams@btinternet.com
If it ain't broke - don't fix it :)

[David Laplante]

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 :)

[Serge]

Access95/97 - 1GB
Access2000/2002 - 2GB

[kleinma]

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!!

[kleinma]

-