I have an Access 2k database which uses the Microsoft ODBC for Oracle driver to link several tables from an Oracle 8.0 database. The problem is that every time I reopen the database and try to open a table / run a query etc I get Access error 3151 - ODBC connection to <database
name> failed. If I then relink the tables all is fine unless I close Access and reopen it, in which case the connection is lost again.
The Oracle database is accessed across a WAN (2mb leased line).
I have at least one other Access application, connected to the same Oracle database in the same way, for which this problem does not occur.
Can anyone offer a suggestion why this might be happening?