Can I link to tables on teradata?

[CherylH]

the source is teradata and I am trying to set up odbc.....it appears to run
but then I get a blank table list......

Thanks!
Cheryl

 

[Mary Chipman [MSFT]]

You'll have to be more specific about what you mean by teradata. What
is the back end database? SQL Server, Oracle, Sybase? What are you
trying to do in Access? Create a linked table to terabytes of data?
Probably not a good idea. Here's some resources that will help you
understand better how Access works when connected to SQL Server data.
The same general principles apply to all server data -- fetch only
what you need.

Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx

What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspf...ifferences-between-access-and-sql-server.html

"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446

--Mary

 

[TroyF]

Mary, I am having the same issue as CherylH, I am unable to link to tables
on a Teradata data source. The source system is "Teradata" not oracle, sql
server or the alternates you listed.

 

[Rick Brandt]

Mary, I am having the same issue as CherylH, I am unable to link to
tables on a Teradata data source. The source system is "Teradata" not
oracle, sql server or the alternates you listed.

If they provide an ODBC driver then you should be able to link to them.
How well the links will work (if at all) is a function of how well the
driver makes the data compatible with Access.

 

[TroyF]

Rick,

Ive got it and use it to access my data warehouse frequently. However when
i attempt to link to a table via the odbc connection, i get "reserved error
(-7722); there is no message for this error."


Thanks.