I'm using an access database with linked tables to oracle, this application has been in production for over 6 months. Have started to have a problem recently when attempting to open a connection (rst.open ...). I'm able to view the data in the linked tables but when trying to open a recordset in VBA code the connection gets dropped and then we have to shut down and reconnect. Sound familiar to anyone, thanks in advance for any ideas?