reposting: ODBC oracle link properties

[Tim Schiermeyer]

Posted earlier with no reply, if any of you have expience with this type of
problem, please reply. I believe it is some type of setting that I am
unaware of. Talk with the resident access expert here and he have no clue
why this is happening on my machine. Once again he was able to set up on his
machine without trouble.

Posted 10/31:
I am linking to a table within an Oracle DB via an Oracle ODBC driver.
Problem I am having is after setting up the machine data source link table,
the user ID is stored in the MSysObject table. For those of you asking is
the save password box checked? - No. For a machine data source this should
not be the case. This is a problem for when I distribute the MDB file it
will hold my user ID and each user is required to log into the Oracle DB
with a unique ID making extra work for myself. On one of the clients
computers I deleted and relink the ODBC linked table with there ID and
password, for some reason access worked as expected, not storing the user
ID. Why is this happening? What changes do I need to make to access so this
ID is not stored?
Thank you
Tim Schiermeyer

 

[TC]

I *did* reply to you - with a suggestion how to fix your problem.

TC

 

[TC]

Friend, I >>>did not say<<< that the registry was the problem!

Re-read what I wrote.

Or not - as you choose.

TC

 

[Tim Schiermeyer]

The registry is not the problem, access is!!!

I *did* reply to you - with a suggestion how to fix your problem.

TC