Here is a description of the problem:
_Multiple desktops with access to a shared drive
_Users need to be able to submit information to a MySQL database on the shared drive
_A Java program will then extract information from the database and send automatic emails via the JEE Mail API
My main concern is concurrency, I'll obvisouly have mutiple users inserting data into the tables.
You access a MySQL database by connecting to its server. It doesn't matter where MySQL stores its data or even where it runs from, all that matters is that the clients have a clear path across the network to the server. And databases are designed for concurrent access, so it's perfectly possible for many clients to insert data at the same time.