Graphical pass-through queries?? 1

[Kubilus1]

I've recently completed work moving an Access 97 DB to a SQL 7 backend. The app is working smoothly thanks largly to the experts here and at other places across the net.

Pass-through queries are relied on heavily in the app. My boss (developer of the original Access DB but not inclined to learn T-SQL) misses the graphical representation allowed on regular Access queries.

Are there any addins, 3rd party apps or otherwise that allow the graphical view and manipulation of Access pass-through queries? I would really appreciate any suggestions in this matter, so far I have found no good examples.

Thank you,

Matt

 

[MichaelRed]

Kublis,

No direct answer form me, but When I was involved with a similar situation, I just maintained a "Test" db in Ms. Access. Let the 'boss' play with that to develop the queries. If they were worth using as stored procedures, translate them and move to the SQL db.

An approach which 'my' user requested (I wouldn't do this one) was to also LINK the SQL tables, so he could do ad-hoc stuff. It wasn't that I was a 'purist', I just didn't think Ms. Access would be able to handle it.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[tlbroadbent]

MichaelRed,

I had to give you a star for your answer. Access is a great tool to develop queries and visualize them but ad-hoc queries in Access can kill performance. Imagine the problems that could occur when user creates the following query, especially if the tables have thousands of rows.

Select table.*, table2.*
From table1 Inner Join table2
Order By col1, col2

We've found that even utilizing linked SQL tables in a controlled manner in Access can negatively impact performance on both client and server. We've made it policy to limit use of linked tables. We do make extensive use of pass-through queries. Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[Kubilus1]

Thanks for the responses.

I'm working here temporarily, as a student (they don't have to pay me as much that way), and there may come a point when my boss may need to change or add queries directly to the SQL engine. Having a test DB alone, though a good idea, isn't quite sufficient. So, is there no such thing as a program that will allow him to graphicaly manipulate these queries as previously possible in Access, do I need to start teaching my boss T-SQL yet?

I'm aware that enterprise manager has a feature like this, but I really need something in the front-end so he can 'visualize the functionality' of the queries from start to finish.

Thank you for any and all help,

Matt