While there are "pro" versions of this script from MetaLinks.com, the free asp shopping cart ( Meta Cart free) is certainly pretty nice as it is.
While Access as database backend might not be the hottest solution as of tiday, it sure does it job pretty well. I also think it would not be too much work to upgrade it to SQL Server yourself.
It features a nice looking layout
A browsable product catalog
A really nice looking product page
Here we have added an item
And now we are reviewing at the shopping cart
And the checkout page
All in all - very nice. Great when you have such a foundation to start with - and the database itself features only 4 tables so it would not be too hard to make adjustments.
I take my hat off for this cart! Easy to install and easy to modify