I am upgrading and optimising an application. I am wondering if I am running queries the best way.
Currently I am using
DoCmd.SetWarnings False
strQryDef = "qupdSsnScrOp"
DoCmd.OpenQuery strQryDef, acViewNormal, acEdit
DoCmd.SetWarnings True

Might I be better using a db.execute method instead to speed things up?
Any thoughts most appreciated. Thanks

I am upgrading and optimising an application. I am wondering if I am running queries the best way.
Currently I am using
DoCmd.SetWarnings False
strQryDef = "qupdSsnScrOp"
DoCmd.OpenQuery strQryDef, acViewNormal, acEdit
DoCmd.SetWarnings True

Might I be better using a db.execute method instead to speed things up?
Any thoughts most appreciated. ThanksDepends...you can't use the db.execute method to SELECT anything, so, if all you're doing is opening a query, and viewing it, db.execute is not part of your alternatives, because there is no action taking place.