[dba-SQLServer] Table Link Refresh Required After Table

Absolutely. MS Access caches the table information. You have to refresh it
ANY TIME a change is made to ANY table in the SQL side.

At 12:00 PM 9/18/2009, you wrote:
>Date: Fri, 18 Sep 2009 11:30:14 -0500
>From: "Dan Waters" <dwaters at usinternet.com>
>Subject: [dba-SQLServer] Table Link Refresh Required After Table
>         Design  Change?
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <630F4D937A334F7394FE62DBBE2FA08A at danwaters>
>Content-Type: text/plain;       charset="us-ascii"
>
>I just added a new field to a table in a SQL Server 2005 database.  The FE
>is A2003.  The FE was closed at the time.
>
>When I opened the FE, it errored out because it couldn't find the new field.
>I opened the table link in the FE and the field didn't show!  Then in code,
>I refreshed all the tables, and still the new field didn't show.
>
>Then I went through relinking just that table, and now the new field does
>show.
>
>This does not happen in Access.  So, if I make a change to a table, do I
>need to explicitly refresh the table link in the FE every time!
>
>Thanks!
>Dan