I'm at the stage where I've managed to make a few pages using Dreamweaver MX and need to link a couple more (containing forms) to a database. The trouble is I know very little about what my options are regarding Dbs. I recently read something on a site which said that the two main types in use are: Access and MySql. Would that be right? It also mentioned that Access is less secure than MySql. I'm open to either, but I'd like to know if there are any other pros and cons. I have quite a lot of information spread out over several tables which I need to search and return information from. I don't know if size makes a difference.

Thanks in advance.

Mikael

Fear is my greatest enemy, regret, my tormentor

My experience is all MySql and PHP on the web. I looked around and found that most servers are running Linux, Apache, Mysql and PHP, all open source. I dislike MS intensely so did not want asp etc. There are plenty of good books about php and mysql. Dreamweaver handles it well too.

I have used access but came from a background of FileMaker on the Mac and PC, once you have used that Access looks amateurish and nerdy. Having said that, once you get into mysql you have to know about tables and relationships and should at least read something about normalisation even if you do not use it.

For me the main things are that it is really cheap and easy to get mysql on the web and there is lots of support. I have not had any speed issues.

I feel sure others will chip in with their 2 cents worth