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

max to number of records?

P: 30
Hi,

I've in mind to build an acces-database in wich a tabel attendance/date would be the central part. It would contain records containing just 2 fields: the ID of a person and a date. There would be up to two hundred persons and the table would be running over some years. The number of records could therefore rapidly become very high. I wonder if there is a max to the number of records in a table?
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
There is no limit on the number of records, just the size of the overall database, which is 2 GBs. There are Access databases with hundreds of thousands of records, some even have a million or more, and these contain records with more than two fields!

Here's a link to one of our HowTos that list the various limits.

http://bytes.com/forum/thread603897.html

Linq ;0)>
Sep 19 '08 #2

Post your reply

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