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

    oracle database connection

    Hello
    I have a problem on link the Oracle tables on my Access program.
    It works fine on my pc because I have the Oracle database installed directly but when I moved the application to the customer's pc I can't link the Oracle tables.
    It seems that doesn't works because the Oracle database is in another machine.
    Is there a way to link the Oracle tables from another server?
    Of course the pc where is loaded the Access application see the server where is installed the Oracle database
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you can :
    if you have the oracle rights,
    if the server is shared so you can link to it,
    if you have the ODBC drivers on your pc.

  3. #3
    atai is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    22
    Quote Originally Posted by ranman256 View Post
    you can :
    if you have the oracle rights,
    if the server is shared so you can link to it,
    if you have the ODBC drivers on your pc.
    yes the server is shared with the pc where is located the Access program.
    But how I can link the Oracle tables?
    If I try I receive an error.
    Can somebody explain me how to link these tables?
    Thanks

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

Similar Threads

  1. Replies: 3
    Last Post: 09-16-2018, 06:26 AM
  2. Replies: 1
    Last Post: 08-18-2017, 10:00 AM
  3. Replies: 1
    Last Post: 03-02-2015, 09:44 AM
  4. Accessing Oracle database
    By rbodhale in forum Access
    Replies: 1
    Last Post: 06-23-2011, 08:18 AM
  5. Automatic Oracle Database connexion
    By 123456 in forum Security
    Replies: 7
    Last Post: 01-28-2011, 03:09 PM

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