UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Dropped Back-end Oracle Sessions In Ms Access, Access 2003    
 
   
whdyck
post Mar 1 2017, 09:26 AM
Post#1



Posts: 219
Joined: 20-July 11
From: Winnipeg, MB, Canada


Hoping someone can help.

We have an MS Access app that connects to an Oracle back-end. After about 10 minutes of inactivity, MS Access's connection to Oracle gets dropped (as per TOAD's Session Browser); a few minutes later, a form (opened when starting the app) looks like the attached.

If I open an Oracle session in TOAD, the session remains intact until I explicitly drop it or close TOAD. But the MS Access connection to Oracle is somehow different.

Anyone know why this is happening in Access?

Thanks for any help you can give.

(Cross-posted to Access World Forums.)

Wayne
This post has been edited by whdyck: Mar 1 2017, 09:36 AM
Attached File(s)
Attached File  Error.png ( 128.99K )Number of downloads: 6
 
Go to the top of the page
 
ranman256
post Mar 13 2017, 07:21 AM
Post#2



Posts: 712
Joined: 25-April 14



The deleted fields are just a sheet that needs refreshed.
Why the connection drops Thru access is puzzling. If you made the oracle links,and set the connection correctly, it should not drop.
Re linking the table should bring everything back.

If it keeps dropping, it must be an oracle setting of your system.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th May 2017 - 09:26 AM