• Post Reply Bookmark Topic Watch Topic
  • New Topic

Shared Database Access  RSS feed

 
B Power
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hsqldb is the obviously smaller db and OpenSource too, while Postgresql is OpenSource too, and stronger than mySql...
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!