I have a access db that is getting data by executing pass thru queries to documentum (Oracle database).
This is executed in a vba procedure, which joins a few separate tables.
If I open access and run the pass thru straight away it works 99% of the time successfully.
However, if I run it initially, and leave access open for some time and try to run again, it comes up with a catostrophic failure and crashes access.
Does anyone have any similar experience and (god hope) a fix or workaround.
Many thanks in advance.
This is executed in a vba procedure, which joins a few separate tables.
If I open access and run the pass thru straight away it works 99% of the time successfully.
However, if I run it initially, and leave access open for some time and try to run again, it comes up with a catostrophic failure and crashes access.
Does anyone have any similar experience and (god hope) a fix or workaround.
Many thanks in advance.
