Updating via code or query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a process that selects data to update/append to different tables.
Which is the fastest way to get this done? Should I utilize queries and
pass parameters? Or should I open the recordset in code and do rs.updates?

Thanks very much for any advice/information!

Janis is MinneSNOWta :)

Merry Christmas!
 
The fastest and easiest way is:
CurrentDb.Execute("querynameOrSQLString"), dbFailOnError

The reason is it going directly to Jet. Just for fun, compare the above to
DoCmd.RunSql("querynameOrSQLString"). This method goes through Access and
runs much slower.

As to the parameters issue, my favored approach it to create an SQL string
without the Where condition, then add the Where condition based on user
selections.
 
Back
Top