Access 97 loosing Oracle ODBC Connection Settings

[Vladymir]

I have an ACCESS 97 database (Can you believe companies still use this???) called "PTS" this databse establishes a connection to an Oracle 8i (soon to be 9i) database, thru a Security file.

From time to time, a window pops up asking the user to re-enter their credentials to access the oracle database for no reason. I have searched everywhere I can think of as to why this may be happeneing.

Anyone have any suggestions why, or atleast how to get around this problem?

Thanks
Jason Armour
KeyBank

 

[PHV]

Did you tick the remember password checkbox when creating the linked table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Vladymir]

No... And for a good reason...

I do not want someone else using my credentials to access the tables... This is a shared environment, where some users simply have read access with no or little update, where as an Admin such as myself needs access to all tables... If it saved my credentials, those people with Read-Only would have full access... Not Good... My clientele have enough access knowledge to break the door down and cause some serious damage.

 

[PHV]

So, each time the connection must be (re]established the credentials are asked.

 

[Vladymir]

Not each time.... Just once in awhile... They log into the Access database using a SYSTEM.MDA file. And every once in awhile, it prompts them for their useer credentials and databse to connect to... Its not even when they leave the pc for 10 minutes... they can be using it over and over, and then all of a sudden, they try to access a table and it asks... and then they try to access another table, and it asks... And then it can be fine for 20 minutes....

Its almost like they are loosing connection because too many people are connecting, but I checked with the DBA, and we have allowances for 150 people, and its only have maxed at 91...