This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Aos Khalifa
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 445
1
Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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 Gibbons
Bartender
Posts: 1110
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 156
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic