linked tables in Access database

Got an Access database that has some ODBC links to Oracle tables. When I
open one of the Oracle tables in my app, I get prompted for the Oracle
password. Obviously, I'm not going to want the users to know that password.

How can I connect my application into Oracle so that I don't see the
password prompt? I've tried a couple of things without success ... using the
"Open" method of the ADO connection object, using the "OpenCurrentDatabase"
method of the Access application object, using the "TransferDatabase" method
of the DoCmd object (which in the ADO docs sounds exactly like what I need).
But none of those do the trick.

Appreciate the help.

John


.

Relevant Pages

  • Re: linked tables in Access database
    ... open one of the Oracle tables in my app, I get prompted for the Oracle ... password prompt? ... of the DoCmd object (which in the ADO docs sounds exactly like what I need). ... Cat: Catalog; ...
    (borland.public.delphi.database.ado)
  • How to set the prompt os it shows current working directory
    ... How do I set the prompt in RHEL 4 so that it shows the current working directory when you login and whenever you change directories. ... When I cd to /u01 it shows that in the prompt and then when I cd to /u01/app it shows that but when I then cd to oracle it doesn't show it. ...
    (RedHat)
  • Re: Chnaging the DB that Tables point to
    ... Have you tried the link table manager? ... Oracle db then if you Select All, check the Always prompt for new location, ... test db without having to relink each one? ...
    (microsoft.public.access.tablesdbdesign)
  • Access and Linked tables to Oracle
    ... In the past I created an Access database front end for our end users ... for the purposes of querying our Oracle data. ... Something around 2 seconds if Oracle has cached the query ... is getting defined for the primary key in the large Oracle table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: oracle and exporting data for a .mdb file
    ... >still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ... Can oracle do it, and where can I find out how to do ...
    (comp.unix.programmer)