I'm attempting to connect MS Accses to a Teradata table with the intention of viewing an object in a BLOB field I have stored there. 
I'm connecting Access to Teradata through a System DSN connction using Teradata driver 15.10.00.00.
My method was to link the table in Access to Teradata through this connection.

I currently use SQL Assistant to write Teradata tables to existing MS Access tables by using the SQL Assistant "Export Results" File option. The problem is that I must manually direct the output to the specific table in SQL Assistant and there are 30 tables that I need to reload each month.

Hi,

I need to access TD (12) using MS Access and/or Excel. My login user name is configured to use ldap for authentication. ODBC version is 12.0.0.1.

A. MS Excel 2007:
The connection steps seem to work smoothly until it displays the list of available TD tables. Then, it displays the ODBC connection dialogue. After entering the authentication details, which I use successfully with TD SQL Assistant, I get the following consecutive error messages.
1. [NCR][ODBC Teradata Driver][Teradata Database] The UserID, Password or Account is invalid.

Hello... I am having a problem connecting to our Teradata database using an ODBC connection within MS Access. I'm using Access 2003, and can connect directly using v12.0 of Teradata SQL Assistant. I can connect to all tables I have been granted access to within Teradata SQL Assistant, however when trying to connect via ODBC within Access, I am presented with the error of "[NCR][ODBC Teradata Driver][Teradata Database] The user does not have any access to the database [my sign-on ID]. (#-3524)"