Accessing Teradata Data from Microsoft Access Form.
Everyone, Here's what I have: I'm doing a SQL Join where one table is in Teradata and the other is MS ACCESS. I connect using ADO and connect fine to the Teradata database. I actually have the Teradata Table linked. So I go to execute the code and start getting formatting errors about expecting something between "," etc. Is it possbile to join a Teradata Table with say MS Access Table? Surely it must be. I've tried to fully qualify the column names but it really does not like the dbo. etc. So does anyone have any thoughts or done this successfully?