max to number of records?

[zaankanter]

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?

[missinglinq]

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