SQL Stored procs vs. pass through query

  • Thread starter Thread starter Miskacee
  • Start date Start date
M

Miskacee

which is better to use? I have parameters and know I must used stored
procedures for these queries, however, which is better for the other queries?

thank you.
 
I suggest you use stored procedures if possible. Since they parse in
the server, subsequent runs will be faster. Plus, they are easier to
call from Access.
 
great. But I can't get my stored proc from sql 2005 to call from Access BE.
How do I do that?
 
You must log in or register to reply here.

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

Similar Threads

Stored Procedure vs. View for Access 2
From Access how to create stored procedure in SQL server 4
Pass Thru queries 6
Parameter Value error in a Subform 0
DoCmd.OpenStoredProcedure won't display altered proc 4
How to link a Access FE to SQL Server BE 10
Using Stored Procedures With Access Data Project 2
Access 07: Creating Procedures 14

Back
Top