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.