"asteroid" <astb612@abv.bg> wrote in message
news:1151498229.595499.282140@m73g2000cwd.googlegroups.com...
> Hi!
>
> I am trying to migrate the Back end of an MS Access based aplication to
> an SQL server 2000. I KNOW how to use passthrough queries in MS Access.
> So, my question is: How can I CREATE a passthrough query from a VBA
> code?
> I want to know WHERE to point that this will be a passthrough query? I
> need something like this:
>
> dim strSQL as string
> strSQL = "SELECT * FROM Table1 LEFT JOIN Table1 ON ...... WHERE..."
> ' how do I point that this should be a passthrough query?
> ' Note that I don't want just to open a connection to the server,
> because this
> ' will mean just to link the source tables
> Me.Form.Recordsource = strSQL
>
> Can you help me to deal with this?
>
> Thanks!
> A.
>