• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Urgent ,Please!!!MSAccess or small PC databases

 
bbkstud
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,
This is actually continuation of an earlier topic. I understand the jdbc.odbc driver shipping with the standard JDK from sun is really a poorman's tool. I am devloping a prototype for my Uni. project. The group involved wants this totally free of cost initially with all open source/free implemetations, as this is for private and not company use, as a way to learn stuff. Provided they like this, they might scale this up, with their bosses' permission. My question is, how do I present this in a way it will be accepted as a uni-project. Will using rmi-jdbc dress this up a bit, making it look professional? Is it possible to run RmiJdbc(remote database server to be used with MS-Access) along with Tomcat?
Thanks!! [LIST]
 
Michael Brewer
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by bbkstud:
Dear All,
jdbc dress this up a bit, making it look professional? Is it possible to run RmiJdbc(remote database server to be used with MS-Access) along with Tomcat?

If you're just concerned about looking professional. Don't worry. Plenty of large, national financial institutions use MS Access.
However, I would recommend PostgreSQL as your database of choice. It's ACID compliant and free.
 
bbkstud
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanks for the response. But do I need to use serialization to be thread safe? Can Access handle multiple transactions?Does Access allow simultaneous insert, update, delete?
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"bbkstud",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
Bosun Bello
Ranch Hand
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bbkstud, I am assuming you meant synchronization. If you are concerned about simultaneous access to the DB, I would not use MS Access. It does not scale very well, if many users will be hitting it. You can also try mySQL at www.mysql.com
 
Michael Brewer
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by bbkstud:
Does Access allow simultaneous insert, update, delete?

I used to support Access 2000 for Microsoft, but I can't answer this question. Jet 4.0 (Access' DBMS) now allows for row-level locking which I would assume would allow for simultaneous inserts, updates, and deletes. Another consideration aside from PostgreSQL and mySQL would be MSDE. MSDE is the Microsoft Data Engine. It's free with MS Office (and may be a free download otherwise). It is SQL Server 7 without the visual tools and throttled to perform poorly with more than 10 users concurrently.
What is your development platform? Windows 2000?
 
bbkstud
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thank you very much. It is windows '98 and,(wait for it!!) office '95!! My proposer says he will give copies/install it on individual PCs to start off with. I guess I might have to do a version using Oracle at College!! Thanks a lot for your input and I might have to just stick to what the proposer guy says, staying away from concurrent transaction, cached rowset implementation et., etc.!!
Thanks once again
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic