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.
posted 8 years ago
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.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads