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 Shared Database Access 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 "Shared Database Access" Watch "Shared Database Access" New topic

Shared Database Access

B Power

Joined: Jun 22, 2004
Posts: 5
I only have access to a shared drive (no database server). If I put a MS Access Database on the shared drive and tried to access it from a Java program on at most three or so different PCs at the one time, how well would that work?

Thanks for your help.
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

All RDBMS's are designed to be multiuser. That is with the exception of MS Access which is notoriously bad at handling anything more than 1 user. You should however be able to use it well enough if your purpose is just to have a convenient DB for development. If you plan to use it for a production system however, I'd strongly advise using something else (MySQL is the obvious freely avaliable DB platform).

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Stefan Wagner
Ranch Hand

Joined: Jun 02, 2003
Posts: 1923

hsqldb is the obviously smaller db and OpenSource too, while Postgresql is OpenSource too, and stronger than mySql...
I agree. Here's the link:
subject: Shared Database Access
It's not a secret anymore!