Corrupted records after linking table

[ITMSTMELL]

Attempted to link to a table on an SQL Server, which included customer records & various contact dates, after the importing the records became corrupted in that they repeated the initial date over & over e.g.

Customer Date
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04

...as opposed to listing same account number but with 4 different contact dates...also when the Access database was opened on a different PC (also Office 2K) the table was displayed correctly?

Has anyone else come accross the same issue, any advice/guidance much appreciated.

 

[quest4]

No I haven't. Are you using an ODBC link? Have you trried run C&R? Maybe try and create a blank dbase and import everything into it. Then run C&R on the new dbase. Just a few suggestion. hth.