[thelist] Buggy Access Linked Tables - Wrong Data

Ed McCarroll Ed at ComSimplicity.com
Wed Feb 2 11:34:59 CST 2005


> 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'.

How are you "pulling up" the cell in SQL Server.  If you're using T-SQL in the
Query Analyzer, could you show us the code?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                             http://www.ComSimplicity.com
(310) 838-4330                      PO Box 654, Culver City, CA 90232
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



More information about the thelist mailing list