I have a number of MS Queries which i need to point to a new SQL datasource .
On pc's both datasources are present as System DSN's.

On opening existing Queries with new datasource, View/tables/criteria and
Criteria menu options are supressed.

New created Queries have no issue.

How can i preserve Query function with a changed datasource?