I have some general knowledge on MS Access 97, PHP, Mysql, NT and Unix.
The company I work for wants me to develop a intranet site so we can access our databases, store templates and keep any records/ files. Which way do I go? Right now all our database programs are Access based.( Product tracking system and our MRP) In the future we might go to Oracle(When we get big enough). We currently have two different server systems NT and Unix. NT which has the control domain groups and unix which is used for internet, mail and file storage. At some point we will want internet access to some of our dbase files.

My requirements
1)I want this intranet to be easy to maintain.
2)Due to the MRP I need real time data.
3)I want to keep the software packages down to a min.

Here is what I was thinking of doing. I was thinking of running a NT web server for the intranet, connecting my dabase to the intranet by coldfusion and generating reports with crystal reports. At some point I could write a script to dump the dbase to a mysql dbase and use the unix for the internet access.

Thanks for any help

Kerry