Prompted for machine data source during Access query

[maxwell2323]

I have an 2010 Access DB on Win 7. I have a query in the DB that often accesses tables that are linked to SQL Server tables. This never used to happen before, but all of the sudden this started to happen. I will open this query and while it runs I am prompted for a machine data source. I go ahead and point it to our SQL server, and the query continues. Not that big of a deal but just annoying. Any suggestions on how to stop getting prompted for this? Thanks in advance!

 

[genomon]

Try re-linking the SQL Server tables. Make sure you are using ODBC provider or Native client 11.0 with a secure password.

Beir bua agus beannacht!