Have a union (marriage) database that the linked tables must be updated for the user to get accurate queried data. Presently I have the users run the queries first that update the linked tables. Then open the union db,but they don't want to do this. I believe there is a way that when the union database is opened, it "calls" a macro in these other databases to run the update query, but I can't find anything. Also these databases are located on different servers. Problem?
Run macro in 1 database when you open another that is linked
- Thread starter telco25
- Start date
