MS Access to MySQL conversion

I'm just getting into the development of dynamic websites, and I have made a nice site with PHP and MySQL, but another site I'm working on runs on a IIS server with no MySQL. I'm wondering if I use just a simple access DB can more than one user of the site access it at a time? If 5 people are browsing the site for the same part is it going to error out to the other 4 or just be slower for them while it waits for it's turn? Also, is there anyway to convert an Access DB to a MySQL DB? I have plenty more questions, but I'll stop there. This forum is great I've learned a lot, thanks for the help.

01. IIS 5.0 will allow you upto 10 concurrent users (IIS 6. only 5), unless you have Server license.

02. If you are developing a real web site DO NOT USE MS Access, its a desktop database not designed for Internet database, It will slow down other application in the server, but if your are doing fun than do whatever you like.

03. There are basically many tools available in the internet to convert MS ACCESS->MySQL

My suggestion is follows:

Write MS ACCESS record to a flat file with any field delemiter, import those data to MySQL using free tools like MySQL Front or other free tool like one you can find here:

http://www.webyog.com/

04. Web server Performance is very close to reverse proportional to number of concurrent users at the server (after the saturation pt.)!

Thank You

Do I have to create the table in mysql before I'm able to import the data, or can I just import the flat file and create a table from that database? I've tried a lot of different methods and I continue to get errors.

Any help is appreciated. Also, do I have to do something to specify the end of a record "/t" or anything like that?

Thanks-

Basically if you use the tool above or MySQLFront, you wont need to create tables (as those tool will create tables for you).
You just need to create a database using menu "Create Database". And export tables (dont forget to check DATA and STRUCTURE options, if it is unchecked).