How to retrieve results of a pass through query?

[dw!]

THis is probably a simple question, but if I have a pass through query that includes a SELECT statement, how do I see and retrieve a recordset that I can then step through and manipulate? I know recordsets retrieved by pass through queries are read only - how do I display the results, or walk through them?
The context would be an mdb front end with SQL server backend.

 

[Vassago]

I like to make passthru queries that then feed to a Make Table or Append query. Once they are in Access, you can manipulate as needed.

 

[pbaldy]

You can also either open a recordset on the pass-through query or base a form or report on it (though as noted the result is read only). What exactly are you trying to accomplish?

 

[dw!]

Thanks for the replies.

I have a big mdb file which is growing and getting slow - the plan is to move to SQl back end/Access front end as a quick interim move before rewriting the whole thing in .NET. So I want to move as many of the queries into SQL now, so that when I port to .NET it's easier.... So what I was hoping for was a few simple code examples for how to pick up the results of a pass through query into DAO recordsets. I can find lots of examples of running action PTQs but none where the results of a SELECT statement get captured.

 

[pbaldy]

This opens a DAO recordset on a pass-through query:

Set rs = db.OpenRecordset("qryCheckCar", dbOpenDynaset)