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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top