Lin B
I develop reports in Access from data in each of 13 separate Oracle databases. I have written SQL Pass-Through queries to provide an instant logon to each one, but need to find a way of logging off from each before getting connected to the next. At the moment I have to close down the Access database and restart it every time. It would be good to put it all into a macro to run all 13, one after the other. Is there something similar to SQL Pass-Through to do this, please?
Many thanks for any help.
I develop reports in Access from data in each of 13 separate Oracle databases. I have written SQL Pass-Through queries to provide an instant logon to each one, but need to find a way of logging off from each before getting connected to the next. At the moment I have to close down the Access database and restart it every time. It would be good to put it all into a macro to run all 13, one after the other. Is there something similar to SQL Pass-Through to do this, please?
Many thanks for any help.