ACTION QUERY IN VBA

[jadams0173]

What, if any, is the difference between running an action query the following ways.

Docmd.runsql <string>

and

Currentproject.connection.execute <string>

Just a curious question.

 

[Zion7]

I personally, am not sure of ALL the differences but,
the arguments for one.

docmd will not return records affected, or an optional
recordset, if desired.

without turning warnings off, docmd will ask for confirmation,
on EVERY record affected.

Docmd.SetWarnings False
Docmd.RunSQL "UPDATE tblSales SET...WHERE txtAmount > 100"
Docmd.SetWarnings True

Dim intAffected As Integer
CurrentProject.Connection.Execute strSQL,intAffected,129

Debug.Print intAffected 'will show how many records were updated

129, will not return a recordset, thus a quicker execution