update alot of record from a form

[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

 

[Graham Mandeno]

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

 

[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

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