Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Jan 2007 @ 19:23:24 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Link Teradata tables in Access 2003
From:   Ferry, Craig

There are a few cons I've run into.

1: If you join linked tables in access to a native access table, you will get 1 call to the database per row.

2: If you refresh the link (due to a password change, etc), you lose any primary keys (on the linked table NOT the terdata table) you define upon linking the table. This only impacts if you need to update the table.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020