Getting Started - cani use access sql?

Print Page | Close Window

cani use access sql?

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Getting Started
Forum Description: Installing, activating, and getting started with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2533
Printed Date: 31-October-2024 at 8:30pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: cani use access sql?

Posted By: a3dcreator
Subject: cani use access sql?
Date Posted: 05-March-2009 at 1:19pm

hi everyone i was wondering if I could use access sql instead of mysql2000 as i am currently using right now. and if it would be more advantagous to do so.

does anyone know if product cart supports Access?
thanks to you all.

-------------
www.wickedresin.com

Replies:

Posted By: Greg Dinger
Date Posted: 05-March-2009 at 1:33pm

I have a couple sites running Access instead of MSSQL, and these are sites which I built when I was fairly new to PC, and didn't know better. I tend to discourage using Access for new clients. With any sort of growing traffic to the site, those stores using Access tend to suffer timeout issues.

There are a couple sites which are small, have limited products, and the merchants do little to increase traffic, and those sites will probably stay on Access. But for the guy who actively promotes his store and has grown his traffic, we have recently upgraded those stores to MSSQL.

Why would you downgrade from MSSQL to Access? Cost? If so, I would discourage that choice.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: a3dcreator
Date Posted: 05-March-2009 at 1:54pm

well i actually did not know i was downgrading.
thanks for making that aware to me.
i am trying to take some classes on ASP but the classes use Access instead of sql2000 which is wwhat we are using now. i just thought since i was gonna learn Access maybe is hould switch to it.
but now im thinking maybee i should find training courses that offer ASP training with sql 2000.

-------------
www.wickedresin.com

Posted By: JoltDigital
Date Posted: 06-March-2009 at 6:56am

Access is not suggested for a website backend. It is a single thread desktop application that does not scale and can actually cause your website to be inaccessable at times. This is due to it being single threaded and odbc/dsn issues that can arise from this. It is especially bad on windows 2003/2008 to the point that once your site gets any kind of traffic you can expect your website application to have to be restarted at least once a week

-------------
http://www.joltdigital.com/host_pc.asp - JoltDigital Inc.
1-888-785-5658
Premium ProductCart Hosting