We would like to determine from users experience is a collection more efficient that a recordset.
We have an access database with several tables, fields and several thousand records.
We can load all of the information into a collection, on each workstation. The collection is draw from 3 tables and covers about 60 fields. Then when a record is changed, we save the data to the collection as well as the database. Occasionaly (during the day) each workstation has to refresh their individual collection (takes only a few seconds).
My question is: Is this an efficient method of displaying and updating information. Is there a better method?
Any advise and experience would be helpful.
Thank you
We have an access database with several tables, fields and several thousand records.
We can load all of the information into a collection, on each workstation. The collection is draw from 3 tables and covers about 60 fields. Then when a record is changed, we save the data to the collection as well as the database. Occasionaly (during the day) each workstation has to refresh their individual collection (takes only a few seconds).
My question is: Is this an efficient method of displaying and updating information. Is there a better method?
Any advise and experience would be helpful.
Thank you