Using Access and a Microsoft ODBC driver to Oracle 8.0

[davesquire]

I'm trying to view data in an Oracle 8.0.6 database via Access 2.73 using the Microsoft ODBC for Oracle.

I can see all the tables and when I open a table, there field names. However, I cannot see the contents in the majority of tables. A few tables I can see content, but most the content shows as: #Deleted

Anyone seen this problem, any solutions possible?

 

[Susanne45]

I believe that your ODBC connection has disconnected. In the Tools, Options, Advanced check for the refresh time for your connection.

Susanne