I'm trying to move some VBA query calls server side to stored procedures to speed things up in a linked table AccessXP/SQL Server 2000 application.
I made a basic stored procedure named CustomerSelect that is -- SELECT * FROM tblCustomer
I have a lot of sql pass through queries in my program like:
db.execute("delete * from tblError"), dbSQLPassThrough
so I tried:
db.execute("Exec CustomerSelect"), dbSQLPassThrough
but it won't run since it is a SELECT query. How do I call this stored
procedure? I tried making a pass through query with CustomerSelect as the only SQL text but every time I run it, it asks for the DSN which is
obviously obnoxious if I want it as part of a larger function eventually.