Accessing MS Access Database , please help .......
Joined: Mar 18, 2012
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 .
and you would be best off putting the connection string in a config file, as it is likely to change for everyone
Joined: Sep 25, 2004
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.
Love is GOD and GOD is Love.<br /> <br />Anand Karia<br />Manager I.T<br />Artistic Garment Ind. Pvt. Ltd<br />MSC (Computer Science)