By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,706 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,706 IT Pros & Developers. It's quick & easy.

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

P: 66
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
Dec 21 '09 #1
Share this Question
Share on Google+
9 Replies


repath
P: 14
more than 2 billion records
Dec 21 '09 #2

debasisdas
Expert 5K+
P: 8,127
I don't think number counts, what matters is size of data.
Dec 21 '09 #3

missinglinq
Expert 2.5K+
P: 3,532
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)>
Dec 21 '09 #4

topher23
Expert 100+
P: 234
This MS article shows the maximums for just about everything in Access 2007.

http://office.microsoft.com/en-us/ac...307391033.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.databasezone.com/techdocs/acclimit.html
Dec 21 '09 #5

missinglinq
Expert 2.5K+
P: 3,532
In point of fact, these limits actually apply to all versions after 97, do they not?

Linq ;0)>
Dec 21 '09 #6

P: 66
Thanks...Does Access 2003 also can store upto size of 2GB or less than that...
Dec 22 '09 #7

missinglinq
Expert 2.5K+
P: 3,532
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)>
Dec 22 '09 #8

topher23
Expert 100+
P: 234
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.
Dec 22 '09 #9

NeoPa
Expert Mod 15k+
P: 31,426
In case anyone tries the link in the earlier post, I've fixed it.
Dec 22 '09 #10

Post your reply

Sign in to post your reply or Sign up for a free account.