I'm using an access database with linked tables to oracle. Have started to have a problem recently when attempting to connect to the oracle database to do a select or even to open a connection. I'm able to view the data in the linked tables but when trying to connect via VBA code the connection gets dropped and then we have to shut down and reconnect. Sound familiar to anyone?