Which way is better?

[Guest]

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

 

[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