Sammie,
You need to make sure that your views are set to share the connection and that your connection is set to display the login dialog only when necessary.
>I am using views of a Oracle database. If I set up a connection to the database I can put in the userid and password and the connection is automatic. If I set up a ODBC view I have to enter my userid and password for each table opened. Is there a way to require one entry of userid and password to access all of the tables? TIA