Access 2007 ODBC Call Failed Error 3146 only on some linked tables when trying to access directly or query.
Same database in Access 2003 does not error and settings confirmed to be the same.
Environment: XP, Access 2007 SP2, SQL Server 2005.
Saw related questions posted on refreshing linked tables in the same environment and also similar issue in system 7.
Any help appreciated