Access 2000 to 2003 - Impacting Performance - Help

[KingPacino]

Hi,

On a windows NT platform I would ODBC to an Oracle server to access live
data held in tables. I would then run queries where I could join local
information from access (2000) held in static tables to the live tables in
Oracle. This was an efficient process and would take seconds to return
results.

My PC now has XP and Access 2003, if I try to repeat the process the queries
seems to hang and after 30 mins+ times out. The ODBC connection has been
tested and works.

This really is impacting on a process that we have and if anybody could help
I would be extremely grateful!

Thanks in advance

 

[easyit]

R U using PassThrough queries?

EasyIT

"Do you think that’s air you're breathing?

 

[KingPacino]

I'm sorry I don't know if I am.

What impact would this have, if any?

Many thanks

 

[easyit]

A pass through query is executed on the remote server, and will return only the needed data. Instead of MsAccess grabbing ALL the data, making a selection en discarding what isn't needed.

This makes a big difference. Your queries should be rewritten in oracle SQL.

You could make a small test bij converting a query that takes a long time to execute, and compare the differences.

If you need help with converting, just post the access sql and the tablenames of Oracle.



EasyIT

"Do you think that’s air you're breathing?