Advice on Database with Server

I have been asked at work to make a medium sized application that each person can use on their own computer but connected to one database which sits on the server. Its just basically an application that each person can add and delete data, but each person should be able to see what another person as just done (kind of refresh their data).

Before i even start this, i thought i would ask for some advice from you experts as to which approach i should be doing.

Thank you.

(cant reply for a few hours, of to golf :))

first you need to decide 2 things
(1) back end database server
(2) front end ( windows form application or web )

for (1) free choices are
(a) MySQL,SQL server express R2,db2-express_C,Postgrey,Oracle express

for (2) VB / C# .net ,asp.net,PHP

remaining things like security,user rights,accessibility etc.. are design time considerations

At the moment we have something similar which i did using vb.net and forms and an access database using OleDb.

I was hoping it was a simple case of taking the database and putting it on the server (which everybody can see at the moment), and everybody have a copy of the program and connect to it ?

The obvious problem for me is the refresh thing.

Thanks for your time.