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.
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.
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.
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.
