Access 2007 ODBC Call Failed Error 3146 only on some linked tables when trying to access directly or query.

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

 

Question Info


Last updated August 18, 2018 Views 19,581 Applies to:
Answer

ANSWER: IBM Driver for AS400 mainframe and/or configuration settings (don't know which one).  We had an upgrade of some kind to the mainframe I my machine was not updated or configured properly.

This was an unusual issue.

9 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.