I have created a Pass through query in MS access. Is there any way that i can pass the DSN as a parameter in that other than using modules in it.

sourav gupta

Sourav,

I think this is the solution, though I may be off the right track...

Starting fresh:
Open a new query (SELECT) in design view.
Right click to bring up the query properties window.
Now turn the query into a pass-through.
The ODBC properties should now be available in the query properties.
Simply navigate to the DSN through the ODBC Admin form...

Hope that helps. Bit of a pain to get there since as soon as your turn it into a pass-through, the properties option disappears so you have to bring it up first! Well, maybe been solved on 2k+, Im stuck on 97 today!

Lee

lucky you :D