Java Application over an industry LAN with Ms Access databases

[chrolg]

Dear friends,
i work for an industry and i have a running project with terrible

constraints.
First let me tell you that all pc's are networked+with shared drives.
There are a number of let's say "source" pc's (less than 10) that operate on

their own (running a VB application) and save production relative data

locally in MSAccess database.
What i have to do is make a java application (or maybe applet) that permits

to someone (from a LAN location) to see analysis and statistics on these

databases .
That is i must make an application(or applet) that connects to these

databases,do some queries,do some data elaboration(like pareto analysis and

statistics stuff) and present some histograms etc.

The problem is that i dont know why way to go:i must point out that i dont

know much about rmi,corba and j2ee stuff but i'm a quick learner...
i already have programming experience with applet and a cgi script with an

apache server.
Also currently there is no server for these pc's but if neccessary i can

request one.


Please tell me (if you can) some possible general solutions ( from the most

easy to the most sophisticated and professional)

Thank you very much,


Chris

[Stuzilla]

Hi Chris,

If you set up ODBC on each of the clients pcs you can then broker your app/applet to use that connection to execute SQL against the selected db. You really have 2 choices to make.

1) You build an app that allows the user to enter the name of the ODBC connection or
2) You define a set of ODBC connection names that will be used across the business and you hard code the connection names into your app

Don't even look at the corba aspect of things. I've used several connection methods, ODBC is the simplest to use

Stuart