I have been looking for an answer to the following question and so far my reference material has been unable to help me. I hope someone here has an answer...
In a multi-user environment with a
VB front end and an Access 2000 back end which method provides a faster result and less network traffic
rst.Open strSQL, cxn, adOpenForwardOnly, adLockReadOnly, adCmdText
or
Set rst = cxn.Execute(strSQL, , adCmdText)
??????
Thanx for your ideas.
Kenny Alligood