Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to close an odbc between MS Access and Oracle

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
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.
 
Status
Not open for further replies.

Similar threads

Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
513
Rudraya
Rudraya
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
498
dcern
dcern
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
807
k5tm
k5tm
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
538
k5tm
k5tm
ceil32
  • Locked
  • Question
ODBC Connection - Windows 7 64 Bit
Replies
0
Views
485
ceil32
ceil32

Part and Inventory Search

Sponsor

Back
Top