Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lag in Link Table Refresh

Status
Not open for further replies.
ejrhodes

ejrhodes

MIS
Jul 9, 2001
20
US
Guys,

I have an ODBC connection opened in Access which links to an Oracle table. It seems that there is a 20 minute delay between the change being made in Oracle and the data being updated in Access. Is there an ODBC setting that I can change to push the update quicker? Is there something I can change in Access to automatically refresh?

Thanks
 
Status
Not open for further replies.

Similar threads

A
  • Question
Print Table attachment
Replies
2
Views
136
andre.meyer
A
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
684
renigar
renigar
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
727
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top