Accessing MS Access Database , please help .......

[Aos Khalifa]

Hi guys

I am a new user and want some help about accessing the MS Access databases from Java ....
I've searched in the web and found some steps to do that but the issue is :
If i want to convert the application to a runnable jar file , How can i use this application on different computers
because i have found that i should refer to that database has been used in the application in each computer will use the application .

Any help ?

[Rajkamal Pillai]

This is what Oracle says about executing Jar files:

http://docs.oracle.com/javase/tutorial/deployment/jar/run.html#1.2

Since in your app you shall be accessing the Db (Access in your case) it must be available on the machine where you are executing it.

Cheers,
Raj.

[Wendy L Gibbons]

and you would be best off putting the connection string in a config file, as it is likely to change for everyone

[Anand Karia]

First of all i would like to tell you that MS-Access database is used specially for single computer. But like in your case you can use single database for multiple users.

Secondly, There are two different ways to connect to MS-Access database. Either you connect database using DNS entry into Windows PC, or you define the exact path of database.

In your scnario, i would prefer using DNS entry into database.

For instance, If you want you all clients to be connected with same single database then put that .mdb file into server and share it fully and allow access to each and every client.
Make dns entry into each computer and select the shared .mdb file.

While using DNS entry, software will use same database.

Hope this scnario will help you out.