Advice requested regarding Access database in Java

From: Lin DeNoyer (lkd1_at_cornell.edu)
Date: 02/24/04 

Date: 24 Feb 2004 16:03:25 GMT

I need some advice. I will be working with a group of students on a
Java coding project. At this point, I probably need the advice more
than they do! Nonetheless, I thought it prudent to ask here before I
meet with the students again.

We have an Access database that is currently maintained through 3rd
party software. The databse contains files of scientific data. The
3rd party software adds files into the database, takes them out,
processes the files. It also maintains a few other columns of
information about each file in the database. (1 row = several
columns of files plus several columns of other information).

We will be moving this processing into Java. We are doing so because
the 3rd party software is costly, and because it is no longer
adequately maintained. The company was sold and we see the
handwriting on the wall. Furthermore, we want to be able to allow
students and other researchers easier access to the type of
processing we do on this database.

So question: Should we continue to have an Access database? Would
something else make more sense?

Thank you in advance for any advice you might give,
Lin DeNoyer

Relevant Pages

  • Re: Copying data between fields
    ... Regarding your comments about database design, I can see that I have not ... Any advice on improving the system gratefully received. ... > not really good design to have a secretary forename field and a director ...
    (microsoft.public.access.formscoding)
  • Listen to the specialists like those in pap government at ur own risks
    ... I wrote about the school principal who had strongly ... urged her Secondary 5 students to give up studying for their O-levels and go ... them are specialists of a different kind. ... So he must often rely on advice from different specialists. ...
    (soc.culture.singapore)
  • Re: New User...create a traditional jet database or SQL Server and
    ... while Access is based on the concept of relational data modeling. ... Database Design for Mere Mortals by Michael Hernandez. ... software, perhaps), then the above advice is not news to you. ... >> guarantee that SQL Server will still be around in 10 years time, ...
    (microsoft.public.access.gettingstarted)
  • Re: Listen to the specialists like those in pap government at ur own risks
    ... urged her Secondary 5 students to give up studying for their O-levels and ... So he must often rely on advice from different specialists. ... Let's now consider our education system. ...
    (soc.culture.singapore)
  • Need help with ASP script.
    ... the beginning process of having a webpage that will direct students to ... I had downloaded a free ASP script which basically uses a ... 'Check the database to see if user exsits and read in there password ... 'Database connection info and driver ...
    (microsoft.public.inetserver.asp.general)