SQL Backend and stored procedures

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Is there any way to call a stored procedure that is on the
SQL backend? Would the server handle the transactions
then or would Access.

For example, I have numerous large tables the I need to
delete and append records too, but when I try running the
queries against the backend, it takes an exceptionally
long time. If the queries were stored procedures though,
would then run faster because the server is doing the
processing versus the local PC?

Thanks in advance

Mark
 
Just create a new query, and make it pass-through.

Then, in the query text, just put in a call to your stored proc

exec sp_CoolStuff

Save the query as "MyStoreQuery" (or whatever)...

Now, to call the stored code...

Currentdb.Execute "MyStoreQuery"
 
Back
Top