Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
quickestore
- Thread starter CFMSACCESS
- Start date
- Status
- Thread starter
- #2
CFMSACCESS
Programmer
I'm trying to find an easy shopping cart solution that will work with MS Access and Cold Fusion.
Take a look at cfwebstore ( ). It's a complete package, built with cf and Access, and everything's ready to go. I used it on a site about a year ago and I haven't had any problems. It's extremely easy to customize, too.
Hope This Helps!
Ecobb
- I hate computers!
Hope This Helps!
Ecobb
- I hate computers!
- Thread starter
- #4
CFMSACCESS
Programmer
It looks like this one works well with Verisign Payflow Link which makes the credit card processing easy.
- Thread starter
- #5
CFMSACCESS
Programmer
Can somoeone please comment on how well Access can handle a large site? Let's say we get 10000 sessions a month and 500 orders per month. Can Access handle that? Or should we use SQL Server?
imstillatwork
IS-IT--Management
I would say access could handle that, others would say no. But being able to handle it, and doing it well are very different 
if you get that much traffic, I would go with a database server (mssql, mysql, etc..), not access.
if you get that much traffic, I would go with a database server (mssql, mysql, etc..), not access.- Thread starter
- #7
CFMSACCESS
Programmer
I think it's easy to change the structure from Access to SQL server, but how easy is it to import the data itself. That is, if I later decide I want to upgrade from Access to SQL server.
Importing is really not a problem. There are tools built into both Access and SQL Server for upgrading an Access database to SQL Server. The problem will be in your cfqueries. For example, Access handles dates differently than SQL Server, so you may have to modify your queries to cope with this.
Hope This Helps!
Ecobb
- I hate computers!
Hope This Helps!
Ecobb
- I hate computers!
- Status