The database is a MDB.   There was an virus with IE7 that required a complete reformat on this PC so I did a reinstall of XP Pro and Access 2003 (complete). ...

This PC is aproximately 6 months old and has been able to link the tables in the past.  I removed MS Access 2003 and reinstalled, I also remove the ODBC...