Archives of the TeradataForum
Message Posted: Fri, 24 Oct 2008 @ 10:25:55 GMT
| Subj: | | Re: Teradata/access |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Fri, 24 Oct 2008 10:57 -->
How are you having Access access the Teradata views?
If you're using the Access interface, then you can either create a linked table or a pass-through query.
The advantage of the linked table is that it understands where there is a primary key (or UPI, Unique Primary Index in Teradata speak) so that
you can live edit the Teradata table. If there's no UPI then Access will treat the table as read-only. It is when you use the Access interface to
make the link that the driver will try to display the available tables/views and will use the default database specified in the driver's interface
(as already noted by Fred W Pluebell). You *can* get around this by VBA coding but I wouldn't advise it.
For almost anything else it is better to use an SQL pass-through query. AFAIK the pass-through query will fully defer permission handling to
the remote (i.e. Teradata) end. This way, the distinction between View and Table is handled at the Teradata. This way also means you get to fully
qualify the table name so the default database is not an issue.
| 
