View Single Post
 
Old August 4th, 2003, 10:04 PM
Kenny Alligood Kenny Alligood is offline
Authorized User
 
Join Date: Jun 2003
Location: , FL, USA.
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default Performance Question

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
__________________
Kenny Alligood