Update Efficiency

[Gassy]

I am running a number of updates on individual records.
Is it more efficient to open each record as a recordset and then do the
update or is it better to create a SQL update statement and use the execute
method of either the connection or a command?
Is it better to use the execute method of the connection object or the
command object to update the single record and what is the difference between
the two and when should one be used rather than the other?

TIA

Mark

 

[Alex Dybenko]

I think best is to build sql update statements and run them using execute
metod

 

[Gassy]

Thanks for that Alex. I am running a system with the data on SQL server and
front end in Access on the client. Is it better to use the execute method of
a command object or the execute method of the connection object.

Cheers

Mark

 

[Alex Dybenko]

Hi,
i dont see a big difference, i would use execute method of the connection
object in most case