Access vs mysql

what to use ,,,

[Acternaweb]

I am trying to organize and display my sports trading cards and memorabilia. I haven't found exactly what I wanted
and don't want to take out a mortgage for what I found since it is not open source. This leads me to my question, what is better to use Access, or mysql?

I don't have formal training in php/mysql but have tweaked several scripts. This is not a commerce site or will it ever be. I am basically looking for a catalog display w/o costs

Greatly appreciate your thoughts

[lorax]

Hoo boy. This one might open up a can 'o worms - again.

IMO it's a no brainer - MySQL for the simple reason it is faster and non-M$.

[Robino]

MySQL is MUCH faster and much more reliable.

[woop01]

Access is in no way shape or form comparable to mySQL, it wasn't meant to be. It is basically a single user version of MS-SQL which is MS product you would need to compare to mySQL.

Access vs mySQL is like comparing a bicycle to a race car. Comparing MS-SQL to mySQL is like comparing a race motorcyle to a race car.

[asquithea]

I've managed to write a substantial data-driven site using Access before, but I wouldn't recommend it. Apart from anything else, Access simply isn't designed to be used via the SQL interface, and it shows.

Use MySQL if at all possible, or SQL Server if (for some reason) you have it available to you.

[Acternaweb]

OK so mysql is my choice, anyone know of any good tutorials for a newbie? I have a basic programming background but by no means seasoned.

Have a book on order but want to get started as soon as I can. I am assuming I can add functionality as I learn it?

[defanjos]

Try http*://www.mysql.com/documentation/index.html

[Acternaweb]

I should add the host uses phpadmin and that tutorial looks like it has physcal access to the server