[AccessD] 2007 Re-Linking Puzzle

 Is this a JET BE?  You should see the changes right away.  If SQL, you need
to re-link to see the changes.

 I have seen in the past where linked tables don't get updated properly, but
that was a thing of the past.

 Not pointing to two different copies of the BE by chance are you (current
table links vs what you re-link to)?

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, February 16, 2013 02:27 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] 2007 Re-Linking Puzzle

I've noticed in the past couple of days that Access 2007 appears to have a
relinking issue. Like any good boy scout, I split the app very early on,
and since I inherited a bad (unnormalized, inconsistently named objects,
etc.) I've been making changes to both the FE and the BE as I go. What I
have noticed is this: despite the changes to field names and some of their
attributes, the FE seems unaware of these changes, and when I peruse the
table structure from the FE it still reflects the old properties, not the
new ones. I tried re-linking, and that didn't make the problem go away. It
appears that nothing works, short of deleting the linked table from the FE
and then creating a new link to the BE table.

Was this always the case, and I simply never noticed before? Or is this
some new "feature" of Access 2007?

-- 
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com