Slow ODBC Connection

G

Guest

Hi,
I’m using front-end in MsAccess 97 and an Oracle 9i database.
My ODBC connection is very, very slow.
It’s almost impossible to work with my link tables.

My colleagues have similar PC as I, don’t have any trouble.
Does any one have some idea why I’m having this problem?
Exists any parameter on windows or Oracle that may the decreasing the
performance?

Thanks,
Tyan
 
J

Jeff Boyce

Several factors come to mind and may contribute ...

The use of anti-virus software.

The speed/duplex setting of your NIC.

The Subdatasheet Name property settings of your linked table definitions.

See also Tony's site for additional factors --
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 ODBC for Oracle linked table issue 0
Appending to VFP 7 tables from Access 2003 w/ODBC 3
Need help with Access 97 and Oracle 9i 6
Allen Browne’s date range vba for more reports 2
A date problem with more than 10 years 8
Query set-up not using cross-tab 9
Pass Parameter from Excel to SharePoint 1
Hours for month as value in query 7

Top