Alex,
The issue is the Make Table and Append Queries. In the wizard, I designated the location of the back end. How can I designate that location with VBA, SQL or Macro? On my AdminF, I can select via a table which BE to link-Primary or Alternate (for on the road laptop). The make table and append queries transfer the on the road changes to the primary when I return.

---

Reply from Alex Hedley:

So are these Queries stored as Objects in the database?
How are you running them, via a Macro or VBA?
If you look at the SQL where does the IN '' point to?
You could use a QueryDef to dynamically make this SQL and run it.