Access can store how many maximum number of records for a db

[shalskedar]

Access can store how many maximum number of records for a db..

Wanted to know what is the limitation of total number of records that Access db can store

[repath]

more than 2 billion records

[debasisdas]

I don't think number counts, what matters is size of data.

[missinglinq]

As debasisdas has said, there is no maximum number of records, per se.

An Access database is limited by the total size of the file, which is dependent on the number of records and the size of those records, as well as the number of tables, forms, queries and reports.

In Access 97 the limit is 1 Gigabyte and in all subsequent versions it is 2 Gigabytes.

Repath's "more than 2 billion records" is way off course, of course, but I know of developers who have running databases holding several hundred thousands of records. I suspect he was thinking of 2 GB limit and simply misspoke.

Once the limit is reached there are ways of keeping the application "alive," such as splitting the database into front end and back end, with the tables/data in the back end and everything else in the front end. The same thing can be done using a different type of back end, such as Oracle or MS SQL.

Linq ;0)>

[topher23]

This MS article shows the maximums for just about everything in Access 2007.

http://office.microsoft.com/en-us/access/HA100307391033.aspx

MS doesn't have the same info for 2003 available anymore that I could find, but a professor from Seattle has it posted for posterity.

http://http://www.databasezon e.com/techdocs/acclimit.html

[missinglinq]

In point of fact, these limits actually apply to all versions after 97, do they not?

Linq ;0)>

[shalskedar]

Thanks...Does Access 2003 also can store upto size of 2GB or less than that...

[missinglinq]

In Access 97 the limit is 1 Gigabyte and in all subsequent versions it is 2 Gigabytes.

in all subsequent versions means any version after Access 97, which would include 2003.

Linq ;0)>

[topher23]

Grrr... that automatic http:\\ in the add link 'wizard' got me again. The link for 2003 was http://www.databasezone.com/techdocs/acclimit.html. It also displays that there were some differences between things like field sizes in older versions. Although the question only related to maximum file size, others looking at this thread may be interested in other maxima.

[NeoPa]

In case anyone tries the link in the earlier post, I've fixed it.