Pass Through Query .sql query

D

deeds

I received a .sql query from a collegue...my question is how do I get this
query into Access? I see the pass through query option...I do that and paste
in the sql query to the blank white page...but cannot get it to run....could
someone step me through this? Thanks.
 
K

KARL DEWEY

Create a new query in design view, click on VIEW - SQL View, paste your
friends SQL over what is in the SQL window.
 
D

deeds

Thanks!.....I had done that but kept getting ODBC call error....I figured it
out....timeout needed to be extended. Thanks again!
 
B

Bob Barrows

deeds said:
I received a .sql query from a collegue...my question is how do I get
this query into Access? I see the pass through query option...I do
that and paste in the sql query to the blank white page...but cannot
get it to run....could someone step me through this? Thanks.

Is this query intended to a)run against tables in your local database,
or b) is it intended to be sent to a remote database?

If a, then passthrough is not appropriate. Just do as Karl suggested and
click the Execute toolbar button (the one with the exclamation point on
it). If it runs with no error, save the query if you need to run it
again, or close it without saving it.

If b (you need to send the query to be run on a remote database), then
you need to select from the menu: Query|SQL Specific | Passthrough. Then
you need to modify the ODBC Connect Str property (connection string) in
the query properties to point the query at an ODBC DSN.
 

Ask a Question

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.

Ask a Question

Top