Results 1 to 10 of 10
  1. #1
    Constance is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default How to create remote client to connect with MS Access?

    Hi, i'm new in Java...

    can i know how to create a link to allow remote client login to the Microsoft Access database in the server side?

    This is the code i have done before, but only can access in server side.

    try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    // set this to a MS Access DB you have on your machine
    String url = System.getProperty("user.dir")+"\\db1.mdb";

    String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
    database+= url.trim() + ";DriverID=22;READONLY=true}";

    con = DriverManager.getConnection( database ,"","");

    } catch (Exception e)
    {

    System.out.println(e);

    }


    pls help me....
    Thank ....:confused:

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    The Access DB would have to be on a shared disk that the client has access to, or you have to create your own server that holds the connection to the db and that the client can communicate with.

  3. #3
    Constance is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default The Access DB would have to be on a shared disk that the client has access to, or you

    Actually i put my Microsoft Access at server side d...
    but i dunno how to write the coding for client to access server side's database..
    Is that any related example for this problem?
    or
    i ned to install third party MS Access JDBC Driver to slove this problem?

    Thank you..:)

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    IOW, you cannot access an Access DB remotely. It has to be available to the local systems filesystem. So, you write a server that communicates with the db, and the client communicates with that server, or you share the disk on which the Access DB resides (but then be prepared for concurrency issues).

  5. #5
    Constance is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default

    erm...my server already communicate with db but how to let client communicate with server?

  6. #6
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

  7. #7
    Constance is offline Member
    Join Date
    Apr 2009
    Posts
    4
    Rep Power
    0

    Default

    i share out my Access DB...
    it work...
    Thank you...

  8. #8
    premi is offline Member
    Join Date
    Jul 2012
    Posts
    1
    Rep Power
    0

    Default Re: How to create remote client to connect with MS Access?

    Quote Originally Posted by Constance View Post
    erm...my server already communicate with db but how to let client communicate with server?
    hi.. i have an issue. I have my guest and host as win XP. my db is in guest and i ran the code from the host machine. the db has been shared between the guest and the host. Am able to access my shared folder in the guest. The issue is, should i add any code in source file(java) so that the client can communicate with db?

  9. #9
    mvidal is offline Member
    Join Date
    Oct 2012
    Posts
    4
    Rep Power
    0

    Default Re: How to create remote client to connect with MS Access?

    This is what is showing in my computer:
    How to create remote client to connect with MS Access?-1-how-odbc-showing-me.jpg
    This is how I want to show:
    How to create remote client to connect with MS Access?-2-how-odbc-suppose-look.jpg
    How can I install the MS Access driver ODBC in my computer
    Attached Thumbnails Attached Thumbnails How to create remote client to connect with MS Access?-3-maccess-diver-suppost-install-there.jpg  

  10. #10
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,455
    Rep Power
    20

    Default Re: How to create remote client to connect with MS Access?

    Get your own thread and ask a specific question. This one's past its prime.

    db

    THREAD CLOSED
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Similar Threads

  1. Replies: 3
    Last Post: 12-01-2011, 07:40 AM
  2. Access Remote Session Bean from an separate web app
    By kiyoharatakuya in forum Enterprise JavaBeans (EJB)
    Replies: 4
    Last Post: 04-24-2009, 04:46 PM
  3. remote access
    By Omarero in forum NetBeans
    Replies: 1
    Last Post: 11-03-2008, 08:36 AM
  4. remote file access problem
    By kib_tse in forum New To Java
    Replies: 2
    Last Post: 08-14-2008, 07:04 PM
  5. Replies: 0
    Last Post: 11-13-2007, 11:13 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
  •