ACCESS capacity

[Guest]

I know, this is not related to access forms coding...

Do u know how much records does the ACCESS can hold? I mean, ACCESS
Capacity in terms of database handling?

 

[Sylvain Lafontaine]

There is no hard limit on the number of records; however, the file size is
limited to 2 gigabytes. Notice that because of internal bloating when you
are updating/inserting data and because of the space required for other
objects like indexes, the practical size for storing your data is less than
that. Also, if you are using linked tables to one or more other mdb files,
the available size will be of course greater than that.

The following article gives you a list of some of the hard limits in Access
2007:

http://blogs.msdn.com/access/archive/2006/06/05/618366.aspx

 

[tina]

open your version of Acces, open the Help file, and search for
"specifications" - that should give you all the info you need about the
"capacity" of a <your version> Access database.

hth