Access 97 with Oracle getting a GPF

[AccessNerd]

I have many aaplications that employ Access 97 as a front-end to Oracle tables. When I am developing, I open a linked Oracle table or write a query against a table or open a form or report that access a table. Then I'll develop a form or report or write some code. This may take 5 minutes or half an hour. When I then try to access a table in any way, Access gets a GPF and closes. Sometimes I loose work because I haven't saved it. I don't understand why the lapse in time between table accesses causes the GPF. And, I can't find any reference to this problem on any tech site. Can anyone shed any light on this one?

 

[BillPower]

1. If you're not already using the Microsoft ODBC for Oracle driver, then try using that. I've had problems with the Oracle for Access driver before and don't use it now.

2. You could try setting up a new DSN accepting the default settings.

3. Have you the latest SP for Access or Office installed.

4. Does this happen on other PCs or just yours.

 

[AccessNerd]

At my office, we always use the Oracle ODBC driver. But, I'll give the MS drive a try. Thanks.