javadatabasems-accessjdbcjdbc-odbc

How to share an Access database to different pc's for a Java desktop application?

I am creating a desktop application in JAVA (RCP plugin) and I am using MS Access as database for my application.

I kept database file on some shared location but whenever I try to open it from different machine it throws exception saying database is already locked by someone else. Please let me know how to resolve this issue.

Is there any way to share an MS Access database file between different machine using JDBC connectivity?

Solution

  • No. This is like giving your car to several people and all of them want to drive it at the same time: It won't work for many reasons.

    Workarounds:

    1. Use a real database like MySQL or H2.

    2. Create a Java server which talks to the Access database. Let all the other programs talk to this server.

    Note: You can't use JDBC in the "other programs" when you use approach #2. You'll have to write your own protocol.