at what stage will access slow down, we want to put 60 000 members in it will it still work well ?
G george Nov 23, 2004 #1 at what stage will access slow down, we want to put 60 000 members in it will it still work well ?
R Rick Brandt Nov 23, 2004 #2 george said: at what stage will access slow down, we want to put 60 000 members in it will it still work well ? Click to expand... If you mean that one of your table will have 60,000 rows in it then that is tiny. Don't worry about it. Performance on a database that is properly designed seldom is affected by its size anyway.
george said: at what stage will access slow down, we want to put 60 000 members in it will it still work well ? Click to expand... If you mean that one of your table will have 60,000 rows in it then that is tiny. Don't worry about it. Performance on a database that is properly designed seldom is affected by its size anyway.
M Mike Labosh Nov 23, 2004 #3 at what stage will access slow down, we want to put 60 000 members in it will it still work well ? Click to expand... We have an Access 97 database here with 3.6 million Contacts in it. You're fine.
at what stage will access slow down, we want to put 60 000 members in it will it still work well ? Click to expand... We have an Access 97 database here with 3.6 million Contacts in it. You're fine.
R Rick Dilley Nov 23, 2004 #4 I have a table with 700,000 rows and it is running on a Pentium 4 desktop with great response time RickD
I have a table with 700,000 rows and it is running on a Pentium 4 desktop with great response time RickD