connect java to remote ms access

[lena1990]

hi all
i want to ask you how to connect java to remote ms access in another computer

thanks in advance

[masijade]

You can't (AFAIK), not like you're thinking. MSAccess is a file, and does not have, in anyway shape or form, a network interface (AFAIK). Place the DB on a shared filesystem and access it directly, but beware of concurrent connections, those are a problem for access.

[lena1990]

i do not understand could you explain more i mean using something like this

String url1 = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "E:\\fast.accdb";
Connection con=DriverManager.getConnection(url);

[masijade]

You do it exactly like that but with "E:" being a shared file system (a shared drive).

[lena1990]

but the ms access database stored in another computer so how it can be reached

[masijade]

THAT is what the SHARED FOLDER is for. Ask your Windows System Administrators (if a business/uni system) or at a microsoft forum if personal.

[lena1990]

thank you for replay what i understand from you that it does not need to put the ip of the another computer to access the ms access database.

[stultuske]

you can also use a webservice, which you call. then you just use the url, and let that webservice do the communication with the db.

[lena1990]

how can i use webservice and what you say