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
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