Which way is better?

C

chemicals

I am trying to determine the most efficient method for querying data on a
backend SQL Server. Most of the queries require a parameter (or two) to be
passed and are all called from the VB code within a Form.

Is it:

A.) OpenRecordset "SELECT * FROM TABLE WHERE CONTRACT='AAA';

B.) Use a QueryDef with parameters

C.) Use an Access Query and pass parameters

Thanks
 
J

Jeff Boyce

There are so many other potential factors (size of table, indexing, network
connections, network traffic load, ...)...

What happens when you try the different approaches?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top