I'm trying to set up a webstore with an ASP based cart. It came with an Access database and the script to create an SQL database. I've got it running with the Access database now but was told I should change to the SQL type because it will make the store run smoother and the database will load more quickly. As you can see from the post below I'm having difficulty setting up an SQL database. Initially I'll have about 5,000 items in the store and around 100 catagories. Since it's goign to be a new site I'm sure it will be low to medium traffic at the most. What I'm trying to find out is how much difference I'll notice in speed using the Access database versus the SQL one? I don't want the site to run so slow that customers get impatient and go else where. If the Access will work ok for me now then maybe I can start with it, learn the SQL and change to it in the future.
John