Results 1 to 4 of 4
  1. #1
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22

    Oracle ODBC Driver connect

    Hi everybody, my first post here.


    I was a VBA programmer in Access long time ago and now I want try to program again to create a new procedure for a data entry that use Oracle tables connected.
    I have created the link to the Oracle database and selected the tables that I need, everything is fine.
    The problem start when I create the form where I use combo box to select the data to insert reading the Oracle tables.
    Everytime the system show me a windows where I have to enter the credentials to connect to the Oracle database.
    What I need is to create the connection only once and then work on my entry form to select the data to insert on my combo boxes without to enter everytime the conncetion credentials.
    Can somebody explain me how to do it?
    Many thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Presuming you linked the tables, there's a checkbox in that process that will let you save the password.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Was it so simple? I went crazy to find a solution!
    Many thanks for your help!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help and welcome to the site!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  2. Path to ODBC Driver
    By cbouley in forum Access
    Replies: 3
    Last Post: 04-23-2013, 10:00 AM
  3. Oracle ODBC 11g Driver
    By GregZip in forum Access
    Replies: 6
    Last Post: 03-21-2012, 03:49 PM
  4. ODBC -- call failed. | Oracle ODBC
    By drdexter33 in forum Access
    Replies: 1
    Last Post: 04-03-2010, 09:32 PM
  5. Replies: 5
    Last Post: 03-29-2009, 07:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums