[X]My Assistant

[lex]

I have an ODBC DSN setup and can link tables and run queries, but they are slow. I therefore want to use a Pass-Thru.

When I setup the query using the linked-table the query runs. Then I change it to pass thru and it runs. if I save, then try to open, I get

 2017_04_09_14_27_38.jpg ( 25.24K )Number of downloads: 1



If I click the 3 dots in Property Sheet > ODBC Connect Str and create the connection string, I get the same thing.

Why? I obviously have permissions if I can get data before saving?

Thanks