Results 1 to 1 of 1
Thread: Connect Access to ODBC
2001-04-09, 16:04 #1
- Join Date
- Jan 2001
- Serbia and Montenegro (Yugoslavia)
- Thanked 0 Times in 0 Posts
Connect Access to ODBC
I have an Access 97 application that I am connecting to an Oracle 7 database.
The application runs several queries before it gets to the Oracle tables. When it finally gets there it prompts the user for his user name and password.
Is there a way that I can open up a connection to Oracle when the form opens so that the user can sign in right away rather than having to wait several minutes after he executes the application? I don't have ADO available to me. I want to reproduce whatever occurs when you try to access a linked table to Oracle in access and it prompts you for sign-in, resulting in all Oracle tables to be available from that point on.