I've been struggling to find a solution to this problem for some time now...ANY help would be greatly appreciated.
I have a master database that executes Insert queries in 2 other databases. These insert queries are each based on 3 pass through queries. I have hard-coded the connect string into the pt queries so that my users do not have to enter the uid/pwd.
My 2 databases are used to pull different data and have different uids/pwds - however, Access keeps the first connection uid/pwd no matter what it shows in the pt queries Connect String Property. I obviously cannot close down Access and reopen it each time I want to change user ids - is there a way to refresh or close the connection in pass through queries?
Thanks-
Nate
I have a master database that executes Insert queries in 2 other databases. These insert queries are each based on 3 pass through queries. I have hard-coded the connect string into the pt queries so that my users do not have to enter the uid/pwd.
My 2 databases are used to pull different data and have different uids/pwds - however, Access keeps the first connection uid/pwd no matter what it shows in the pt queries Connect String Property. I obviously cannot close down Access and reopen it each time I want to change user ids - is there a way to refresh or close the connection in pass through queries?
Thanks-
Nate