MS Server & Database help help needed

Hello,

I have a Microsoft 2000 server and a database (in MS Access) with about 3500 entries which are queried heavily throughout the day.

MY Issue:
The database is setup in MSAccess and I am not really exp with Access. I am more knowledgable in PHP and MYSQL database.

What I am looking for:
I need an easy/user friendly way for staff to add entries to the database with out allowing duplicate entries being made in the dbase. Also need a easy way to delete/modify entries as well as being able to query the database based on multiple criteria.

So would I be better staying with using MS Access and try to learn a way to better set it up to allow mutliple criteria seraching and prevention of multiple duplicates. (Although MS Access does not currently work well for us.
Or should I setup a PHP script and MYSQL on my Windows server.
But can MYSQL and PHP be setup on a windows server with no difficulties??

Please let me know what is best way to go

thanks

 

 

 

 

Top