I have set up a linked table (an ODBC to an oracle database) and when first accessing the table am prompted for the username and password to access it. This is fine and i can use the database and access the oracle tables with no problem. That is unless i leave the database open for any period of time. then when i try to access a linked table, i have to re-put in the password about 3 times before the query or report that is accessing the oracle database opens, and it generally takes about 1 minute longer than if i was to close the database, re-open it, type in the username and password again once. is there anyway i can keep the link with initial username and password open for the entire time the database is open without having to re-enter it?