Poor Performance Linking to Oracle Backend

  • Thread starter Thread starter stara
  • Start date Start date
S

stara

Hi,

Currently we have Microsoft Access database with tables linked to Oracle
views. However with certain queries, it takes about 9 hours to run. The
linked tables have about half- million records. The query uses linked table
and few local tables. I'm not sure how to improve performance. I even tried
ADP. I tried to use ADO programming to link to Oracle back-end. But still the
performance is bad.

Could you please suggest ideas?

Thanks a lot,
Stara
 
This NG is about MS Access ADP, which can only use SQL Server/MSDE as back
end, no linked table, or other type of back end (thta is, you cannot try ADP
wirh Oracle back end). You need to post to other NG, such as

microsoft.public.access
microsoft.public.access.odbcclientsvr
 
Back
Top