I have a computer project where I have to set up a database which can
be accessed using a java gui (three different front ends for three
different types of user). I am thinking of using MS ACCESS as the
database and using the java.sql stuff to access it. Is this the best
solution (easiest solution?). Will I come up against many problems?
What are the pitfalls and where can I find info/books which will help?

Please reply!!! Thankyou