How come when using an Oracle table with Access its so SLOW

Guest · May 19, 2005

Im trying to use Oracle tables in Acccess and it takes so long to run a
query. Why is this and how do you get around?

Lynn Trapp · May 19, 2005

Well, that depends on what you are trying to do and how you are trying to
do it. Some Oracle tables are rather large and if you are trying to pull in
the entire table it can move pretty slowly.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

Export an Access table to an EXISTING Oracle Table	1	Aug 4, 2009
ODBC Connection to Oracle database is very slow	0	Aug 10, 2009
MS Oracle ODBC failure in Access 07	3	Sep 28, 2009
Linking Access and Oracle problem	4	May 18, 2007
Linked Table Issue to Oracle	1	Dec 8, 2009
Linked Oracle Table Slow in 2007	1	Oct 24, 2008
Access Relationships (Oracle Tables)	1	Jan 23, 2008
oracle sql plus - modified table column - not showing in Access	1	Mar 24, 2009

Ask a Question