update alot of record from a form

  • Thread starter Thread starter thread
  • Start date Start date
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
 
If you are performing the same update to all the selected records, then it
is much faster to execute an update query.
 
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...
 
Back
Top