How to create remote client to connect with MS Access?

[Constance]

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:

[masijade]

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.

[Constance]

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..:)

[masijade]

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).

[Constance]

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

[masijade]

Trail: Custom Networking (The Java™ Tutorials)

or

Trail: RMI (The Java™ Tutorials)

[Constance]

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

[premi]

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?

[mvidal]

This is what is showing in my computer:

This is how I want to show:

How can I install the MS Access driver ODBC in my computer

[DarrylBurke]

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

db

THREAD CLOSED