MS Access or MY SQL????

Asp.net using MS Acess or My SQL
I was just wondering if anyone could give me some advice on which database to use. I have to create a buying site in ASP.Net and was going to use MS Access for storing all my data in, but ive been looking on the net and seen a few articles on My SQL, i was just wondering what actaully is it? and is this was a better database package to use?

And if so where would i get it from?is it easy to use?would it be more benificial that using MS Access?

Thanks

Homer

Personally I would use SQL Server for ease of use, and it has a lot of features like stored procedures. But SQL Server is relatively expensive. MSAccess was not designed for e-commerce. I would not use it for an e-commerce site.

( Go here for more about this: http://www.aspemporium.com/aspEmpor...UseMSAccess.asp )

Well, mySQL is free, but less straightforward to use in my opinion. Typically it is used on Linux systems, but there is a Windows version. I hope this helps!?!

SQL server is rediculously expensive isn't it? Was the my SQL a misstype? If not, yea, it's a pretty good db. I prefer it over msACCESS personally. It does indeed lack stored proceedures but it's free of charge last I checked to use and it gets more powerful each year....I guess what's really important is how much you need your database to do and if mySQL can provide all of that.

It seems that mySQL is starting to support stored procs....

http://news.com.com/2100-7344_3-513...ml?tag=nefd_top

where can i get mysql from?

mysql.com

There are a number of options available to you depending on your expected traffic but none of these options should contain Microsoft Access.

Microsoft Access is not a good database to choose for scaleable web applications. File based databases, like Access, suffer a performance hit when many users try to access the records at the same time or when the number of records is large.

If you anticipate a small amount of traffic, at first, and you want to go the Microsoft route then i would strongly suggest using the MSDE. MSDE is crippled in that it has a workload governor that prevents you from using it in a high workload environment but it gives you an easy upgrade path to SQL server.

MySql is free and a highly scaleable database (Slashdot.org, for example, uses MySQL extensively).. It isn't a fully relational database though and it doesn't have some of the advanced features of SQL Server. For most situations, it's fine however.. I'd strongly recommend it for your application

Simon.