G
Guest
How do I run stored SQL Server procedures or view queries from an mdb? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lynn Trapp
You can call stored procedures with a Pass Through Query. You can also do
the same for queries or, else, you can link the SQL Server tables in the mdb
and run queries as you usually would.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
the same for queries or, else, you can link the SQL Server tables in the mdb
and run queries as you usually would.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
G
Guest
Thanks! That's what I thought. I am already running mdb based queries, and at
times performance is slow, so I was looking to put the whole thing in SQL,
sans converting to adp. The app is already running and it's too much grief to
convert and do all the testing all over again. I'm having a lot of troulbe
with queries that do a delete * (all the rows) in Accecss not running on the
backend SQL table becasue of indexes. Seems no matter what I do it breaks, so
I would have to change to a truncate table, I guess.
times performance is slow, so I was looking to put the whole thing in SQL,
sans converting to adp. The app is already running and it's too much grief to
convert and do all the testing all over again. I'm having a lot of troulbe
with queries that do a delete * (all the rows) in Accecss not running on the
backend SQL table becasue of indexes. Seems no matter what I do it breaks, so
I would have to change to a truncate table, I guess.
S
Sylvain Lafontaine
It is possible that even with SQL-Server, times performance might be even
slower than with a MDB file as the backend if you are simply using linked
tables. To make things snappier, you will have to use Views for all your
jointed tables.
See http://support.microsoft.com/kb/q209123/ to have updatable Views in
Access.
slower than with a MDB file as the backend if you are simply using linked
tables. To make things snappier, you will have to use Views for all your
jointed tables.
See http://support.microsoft.com/kb/q209123/ to have updatable Views in
Access.