transfertext from passthrough query

[Crowley16]

I've got a passthrough query which retuns the results of a function from sql server back end.

however when I try to transferText from this query, it says object is not supported.

ideas anyone?

--------------------
Procrastinate Now!

 

[easyit]

Hi,

Don't know why, but maybe this will work:
use the passtrhough query in regular query - and use the regular query in the transfertext?

EasyIT

 

[Crowley16]

yeah, that's what I've been doing, however this is not a very clean way of doing things and I was wondering if there was a better way to deal with this, i.e. without having to make up a new query...

--------------------
Procrastinate Now!

 

[easyit]

Write it as a nested query?

Select AliasName.* FROM (
...your passthrough sql...
) AS AliasName

It is just a little extra code in your pass trough query...

EasyIT

 

[Crowley16]

I've tried that, unfortunately it doesn't work.

it looks like access won't let you do a transfer on any sort of pass through query...

--------------------
Procrastinate Now!