Results 1 to 4 of 4
  1. #1
    ajeeb is offline Member
    Join Date
    Dec 2008
    Posts
    30
    Rep Power
    0

    Default Accessing a remote Microsoft Access database

    Hi,
    As we access a remote oracle databse (remote-> on a different machine), is it possible to access a remote access database ? If yes, what changes should i make to the connection string below to access the same:

    "jdbc: odbc:MyDSN", "username", "password"

    This particular DSN (MyDSN) resides in my system.

    i.e. The access database (.mdb) will remain in a different machine and will also have a corresponding DSN in the same system. What connection string should I use to access this databse from a java applcation in my machine ?

  2. #2
    satkk is offline Member
    Join Date
    Apr 2009
    Posts
    8
    Rep Power
    0

    Default Re:

    If your database resides in another system, then u can do it with DSN settings,
    instead of selecting your own hard drive for searching database, u can select the option network, and browse for the machine and database, click ok

  3. #3
    satkk is offline Member
    Join Date
    Apr 2009
    Posts
    8
    Rep Power
    0

    Default

    sorry , the case was not for oracle..:(

  4. #4
    abeythampy is offline Member
    Join Date
    Dec 2011
    Posts
    1
    Rep Power
    0

    Default Re: Accessing a remote Microsoft Access database

    Hi,
    I am facing an issue while connecting to ms access db in shared drive without using DSN.While debugging java compiler crashed after executing Connection statement(DriverManager.getConnection()).I am using java1.6.Can anyone help in solving this issue?

Similar Threads

  1. : Accessing remote directory???
    By vaskarbasak in forum AWT / Swing
    Replies: 3
    Last Post: 10-15-2009, 09:19 AM
  2. remote access
    By Omarero in forum NetBeans
    Replies: 1
    Last Post: 11-03-2008, 08:36 AM
  3. remote file access problem
    By kib_tse in forum New To Java
    Replies: 2
    Last Post: 08-14-2008, 07:04 PM
  4. Replies: 1
    Last Post: 08-07-2007, 08:51 AM
  5. connect to microsoft access
    By bbq in forum JDBC
    Replies: 1
    Last Post: 07-09-2007, 04:33 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
  •