Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maximum record for microsoft access database
- Thread starter manisa
- Start date
JohnYingling
Programmer
Easily. Maximum is way above 3000.
Hi,
It depends a lot on the complexity of the data stucture (and of your queries and updates). Microsoft recommends that your tables should have less than 10.000 rows, but I've made a database (with a very simple structure) that had more than 1 million row and it was running just fine...
Sunaj
It depends a lot on the complexity of the data stucture (and of your queries and updates). Microsoft recommends that your tables should have less than 10.000 rows, but I've made a database (with a very simple structure) that had more than 1 million row and it was running just fine...
Sunaj
- Status
