Query from Teradata table

[kidrobot]

I'm querying off of a pretty huge linked teradata table. I've ran the exact same query in another querying program and it only returns 2,000 records. Although when I run the same exact query in Access I get the error

"ODBC--call failed.

[NCR][ODBC Teradata Driver] Query timeout expired (#0)"

Does anyone know why? Does this mean the table too big to query from?

 

[Dennisk]

have you tried a 'pass through' query?
is the server a M$ SQL, if so you can create views on the server and then use an access project (.ADP) file to access the view.

 

[kidrobot]

have you tried a 'pass through' query?
is the server a M$ SQL, if so you can create views on the server and then use an access project (.ADP) file to access the view.

I've never really dealt with this so I'm not sure. If you can further elaborate or link me to a relevant site that would be great.