• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in Remote Database Access (.mdb)

 
Murali Rajamanickam
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In our java based application we store our information in a database. We use Microsoft Access as database.
We want to place the database in a remote system in the network and access the same from different system.

How can we access the remote database (*.mdb file placed in a system in the network) in our java application .
What type of JDBC ODBC driver must be used for this purpose.
Does MS Access support this feature.

Kindly provide us the information regarding the same and if possible some source code.

Thanks for your help.
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch.

As long as the directory the MDB file is in is shared, you should be able to set up a System DSN for it, just like you'd for a local database.

It's also possible to point to the MDB file directly without setting up a DSN; see here for details.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic