odbc failed message on only one table

[PreacherUK]

Hi All,

I have an access database that is linking via a DSN to some paradox(version 10) tables. All but one of the tables is fine, when I click onto the offending table I get told that 'ODBC Failed' and the fields in the table are populated with multiple ####'s.

This is only affecting one table out of around 5. Any general advice, based on my pretty thin information?

 

[genomon]

Try relinking the table from scratch (not using the wizard). If it was linked with a bad dsn this could fix it. Also make sure that the table will open in its native environment (make sure it hasn't become corrupt).
Hope this works!........

 

[PreacherUK]

Thanks for the feedback Genomon. I had tried all that, which is why I was at a loss

It turned out that the source table, a Paradox table needed to be 'repaired' despite being perfectly 'open-able' from a Paradox interface.

Still live and learn.

Thanks

Dave