ODBC oracle link

  • Thread starter Thread starter Tim Schiermeyer
  • Start date Start date
T

Tim Schiermeyer

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
 
Are you worried that *your* ID is being stored (and therefore, potentially
visible to other people), or that you must change it (on each PC) to *their*
ID (thereby copping extra work for yourself)?

If the latter problem is the real problem, then, write some startup code in
your application to check a registry item (say). If the item does not exist,
this is the first run of your application on that PC. Prompt the user for
their oracle username, then programatically relink the tables using that
name. Then set the registry item so this does not happen again.

Yes? No?

HTH,
TC
 
The problem as of now is not in the registry, it is in the access database
itself. In the Msysobject table. Yes it is also stored in the registry and
yes I have code to change the registry entry. Also my issue is with number
2.
Tim
 
I have made changes to the registry and the data is still pulled into the
Msysobjects table, outside of what is in the registry. After changing the
registry entry and then relinking the table the user id still appears in the
Msysobjects table.
Tim
 
Well, you said: "my issue is with number 2".

Now you seem to be saying that the issue is with number 1.

Maybe someone else can help.

TC
 
Back
Top