Hi, I'm working for a company and they want me to design an intranet. I'm quite competent at creating websites and am eager to learn how to create 'dynamic' websites. What software would I use?

I use dreamweaver at home, could I use this and read up about asp.net to create database functionality to create a people search for employees etc...

We use a windows server that does not support PHP or MySQL i think.

We already have an access database - could be the foundation to my web site?

Any suggestions?

Depends on how well the Access database is designed. If you've named your fields properly and normalized it and all that, it would be plenty for an Intranet.

You sound like you have all the pieces...you just need to join 'em.

ASP.NET talks to Access out of the box, or through ADO.NET anyway. You simply declare a new OleDbConnection, and then do whatever you like with it - delete records, wrap data in html, whatever. Use connection pooling, and open them at the last possible moment, then close them as soon as you're finished with them. That's particularly important with Access.