ODBC auto connect

[AA]

Hi,

Currently, I linked part of the database to Oracle using
ODBC.

I want to automatically (ie avoid username and password
prompt)run query from access.

Anyone know of a way in VBA on how to do that?
Thanks

 

[Tony]

To automatically run a query (without entering the
username, password, and server) from linked Oracle tables
you will need to edit your OS registry with the Username,
Password and Server. It is the ODBC DSN configuration
which is prompting you for this information. To do so you
will need to select-Start-Run-Regedit to open the
registry. Search for the DSN that uses the Oracle tables,
then under PWD enter the password, Server enter the Server
name and UID enter the user ID.

HTH,

Tony