Results 1 to 2 of 2
  1. #1
    mapache is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    3

    oracle Link table query


    Hi All,

    In my access i have a link table (oracle) and i can do queries from my computer cause i have the driver installed.
    Ex:
    Code:
     select distinct dept from [ODBC;DSN=dsn;server=server.com;uid=user;pwd=password].table_name
    i'm doing this query to enter the username and password by query.
    My problem is when someone (in other computer) query the access they need to have the driver installed(the only way that i know is to install client oracle wich is a bit heavy).

    I tried with "MS Remote" without success.
    Does anyone know how it works the ms remote provider? or if you know a better solution?"

    Thanks in advance,
    Mapache

  2. #2
    mapache is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Posts
    3
    FYI,
    I cross posted this topic in another forum...

    http://www.access-programmers.co.uk/...57#post1209357

    Thanks,
    Mapache

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

Similar Threads

  1. Replies: 1
    Last Post: 10-15-2012, 02:41 PM
  2. Replies: 2
    Last Post: 12-20-2011, 07:33 AM
  3. Replies: 2
    Last Post: 08-01-2011, 11:35 PM
  4. Export table from Oracle to Microsoft Access 2007
    By dba in forum Import/Export Data
    Replies: 1
    Last Post: 02-25-2011, 07:05 AM
  5. Oracle table name exceeds 30 char?
    By workindan in forum Access
    Replies: 0
    Last Post: 12-08-2010, 02:59 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