[thelist] Buggy Access Linked Tables - Wrong Data

Rob Smith rob.smith at THERMON.com
Wed Feb 2 10:01:12 CST 2005


Here's one for ya.

We have an Access 97 GUI that uses Linked tables to an SQL Server 2k box. In
this one particular instance we have something like 'XYZ ABC 123' However,
when I pull up that same identical cell in the SQL server all I get is 'ABC
123'.

If these are linked tables how can this be? Oh, this data hasn't been
changed in over 3 years and the tables have been (re)linked many times since
then. 

Rob Smith


More information about the thelist mailing list