File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Accessing MS Access Database , please help ....... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Accessing MS Access Database , please help ......." Watch "Accessing MS Access Database , please help ......." New topic

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

Aos Khalifa

Joined: Mar 18, 2012
Posts: 5
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
Ranch Hand

Joined: Mar 02, 2005
Posts: 445

This is what Oracle says about executing Jar files:

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.

Wendy Gibbons

Joined: Oct 21, 2008
Posts: 1107

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

Joined: Sep 25, 2004
Posts: 156

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.
Anand Karia
IT Concretor.......
M/s. Anand Karia Concreting IT
I agree. Here's the link:
subject: Accessing MS Access Database , please help .......
It's not a secret anymore!