Access Linked Query SQL

Mar 7, 2024
Reaction score
I am trying to do a simple update query for a linked SQL database, but have it change databases based on what was selected on a form. There are many databases for the same tables - just different data. For example: A user clicks a database on a form - that will change the linked SQL database to that database (and if you hover over the linked SQL tables you can see the database has changed). But, when I go to run the query that has the table I want updated it shows the default database.
Database is set to (current) on the Query.
Thank you for your help!