Access application opens multiple session

[snjv]

Hi!
I am facing a starnge problem in one of my access application.To elaborate ym problem.I have one application which use link table to oracle data base trough ODBC.If I open some form to do some activity and keep it open for some time(idle).Then again start using it its open new session for the application.
We have Virtual private database setting on oracle which set context for every session.This context sets when user selects some option using oracle procedure and it should be valid for that user.
It work fine in single strech but is I open the form choose some option (cotext sets for that sesion).After some time it open another session so we lost the context as it is new seesion.
in nut shell I want to keep only one session per user regardless of time and use.

is any one has any idea how to accomplish it.
Your input is valueable for me.
Thank in advance
Regards
snjv

 

[kraxmo]

Here are a couple of ideas:

1. Time-out (close) the application after a specific time period (5 minutes?).
2. Dynamically link the table at run time, read the data into a local table, and drop the link.
a. This works well for read-only data but requires more work for updates (similar to using an unbound form for transactions).
b. If data latency is a problem, refresh after a specific time or timeout per #1.
3. Using ADO, read data into a recordset, save to file, disconnect, and read file via ADO persisted recordset.
a. Same as #2 for read-only vs. transactions (i.e. you will need to open a new connection to detect row/columar changes and issue SQL Insert/Update/Deletes).
b. Same as #2 for data latency.

Jim Kraxberger
Developing Access solutions since 1995
jkraxberger@scp4me.com