I'm seeing some strange behavior when I run a pass through query. I am passing it through a Teradata database. When I execute the queries the records seem to appear almost instantly in the query reults window, but if you try to go to the last record (ctrl+down arrow) or copy the contents an hourglass appears and I sometimes have to wait for 3-4 mins for it to go to the last record.
I'm just wondering if I have asetting wrong, or string to database setup wrong? I have the access databae in SQL ANSI92 mode.
Thanks
I'm just wondering if I have asetting wrong, or string to database setup wrong? I have the access databae in SQL ANSI92 mode.
Thanks