P-T Query Returns Records Error

I

Ivan Grozney

I have a Pass Through query that I am sending to an SQL server. It is
running a link to an AS/400 system. I am linking 5 tables and creating my
own table on the SQL server from the AS/400. The reason being that users get
confused if the AS/400 password is different then the AD password, I get
calls and I wish to avoid them if possible…

When I set up my P-T query it works fine but I get the message…

Pass-through query with ReturnsRecords property set to True did not return
any records.

I go into the properties and set the Returns Records to NO and I get the
following message

The Microsoft Jet database engine cannot find the input table or query
‘ODBC;DSN=SLSQL;Description=SQSQL;UID=blahblah;DATABS’. Make sure it exists
and that its name is spelled correctly.

How can I get this to work and not show any messages? I tried (didn’t think
it would work but I had to try…) leaving the Returns Records to YES and
SETWARNINGS FALSE but I couldn’t think of anything else.


TIA,

Vanya
 
Top