Call Limit IO Usage Problem...Please Help????

[5150]

When running Access 97 the user gets a message about exceeding a call limit on IO usage. Canm anyone please tell me why I am getting this and how to fix it?

Thanks

 

[tlbroadbent]

What is the user doing? Opening tables or queries, accessing a back-end database, running VB code... Or does the error occur upon opening a database? Does it occur on only one database or several?

It will help to know what you are dealing with. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[5150]

It is happening when he is running against a large attached Oracle table. We gave him unlimited process time but the error is still occurring. Any thoughts????? The exact error message is :

Microsoft Access (window)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-02395:exceeded call limit on IO usage (#2395)


Thanks

 

[tlbroadbent]

This is an Oracle message. I'm not familiar with Oracle but a quick Web search turned up the following.

ORA-02395: exceeded call limit on I/O usage
Cause: An attempt was made to exceed the maximum I/O for a call, a parse, execute, or fetch, allowed by the LOGICAL_READS_PER_CALL clause of the user profile.

Action: If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_CALL limit of the user profile.

Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot