update alot of record from a form

T

thread

hi all,
i need to update alot of records from a form.
for now i'm using recordset to loop the records and update the relevant
but when there is alot of record,its taking 4-5 minutes until its been
updating the table.
what is the fastest way to do it
 
G

Graham Mandeno

If you are performing the same update to all the selected records, then it
is much faster to execute an update query.
 
T

thread

no,the updating should depend every time on diffrent groups
i looping with recordset but it takes too much time,i think an execute
of SQL sentence will be faster but im not sure

Graham Mandeno כתב:
If you are performing the same update to all the selected records, then it
is much faster to execute an update query.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

thread said:
hi all,
i need to update alot of records from a form.
for now i'm using recordset to loop the records and update the relevant
but when there is alot of record,its taking 4-5 minutes until its been
updating the table.
what is the fastest way to do it
Click to expand...
Click to expand...
 
Top