Dear All,


I feel, once again, like I'm banging my head against a brick wall. We seem to have a lot of trouble with the connection to our Oracle database via ODBC from MS Access, and wondered if anyone here would be able to pin-point exactly where we're going wrong.

Basically, we have a table on our Oracle database which contains 797,236 records - not a lot, but a fair amount for what we do. This table is by far the largest, but we frequently have problems with Access database routines hanging when browsing this table.

If anyone can give me help with this, I would be very grateful.


Many thanks in advance,
Paul.