Java Project : Help needed

[p_2001]

Yesterday I accepted a JAVA project from a neighbor who runs a show room.

What he wants is a software which helps him manage MS-Access database...

The project needs
1)  2 databases are defined in ACCESS. Here the first database is for prospected clients (  those that enquired via telephone or "walked" in...
2)  The user fills in data and presses a "SAVE" button to save the data to the database.
3)  Modify data as required ...
4) Display different views of database such as on the basis of product the customer is interested in..
5) When the second database(for those who tested them) the FIRST database is updated automatically and sets a flag on the customer.

There are many more features, but I can manage them on my own...

What I've decided is to make a LANWARE... The server will operate on the database while the client interacts with the user.. the client will send requests and server will send the table data in arrays.... the arrays will be shown and modified data will be sent back to server..

what I need help in is the  ACCESS-DATABASE part. I know sql but I do not know how to manipulate ACCESS database through java.

If someone can point me somewhere it would be appreciated.

[Stackprotector]

Take some time for research, there are loads of libary's on google, and see wich one is the best for your job

[Kulverstukas]

Why access? Why MSSQL? Why MICROSOFT!?
I would just create 1 java app that acts as a client that connects to the database, retrieves and puts data. The database is already operating as a server so you don't have to write a server-side java app to the job. You should just find a library that fits your needs and work with it.

Also you might be better off asking this in Stackoverflow.

[xor]

Access even had front end abilities.... Just make a front end in access, convert it to an MDE and release. You split UI and Data databases apart. Why add an extra layer of difficulty in by making it a Java project?