Well the pro's for Access are easy to create and manage "small" datastores, can use query builder to build queries. Cons for Access are performance problems with larger tables and probably the biggest is scalability on a concurrent use connection standpoint. I have seen performance seriously degrade well below the stated 64 users that MS uses in thier docs. Also there is not any way to perform triggers and stored procedures among other things. Basically if you are only going to do a "small" site with very little chance of more than say 10 concurrent users use Access, otherwise get something better like SQL server or mySQL.
H