ProductCart Shopping Cart Software Forums : cani use access sql? https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:02:52 +0000 Fri, 06 Mar 2009 06:56:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2533 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[cani use access sql? : Access is not suggested for a...]]> https://forum.productcart.com/cani-use-access-sql_topic2533_post9189.html#9189 Author: JoltDigital
Subject: 2533
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

]]> Fri, 06 Mar 2009 06:56:30 +0000 https://forum.productcart.com/cani-use-access-sql_topic2533_post9189.html#9189 <![CDATA[cani use access sql? : well i actually did not know i...]]> https://forum.productcart.com/cani-use-access-sql_topic2533_post9172.html#9172 Author: a3dcreator
Subject: 2533
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.

]]> Thu, 05 Mar 2009 13:54:07 +0000 https://forum.productcart.com/cani-use-access-sql_topic2533_post9172.html#9172 <![CDATA[cani use access sql? : I have a couple sites running...]]> https://forum.productcart.com/cani-use-access-sql_topic2533_post9171.html#9171 Author: Greg Dinger
Subject: 2533
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.
]]> Thu, 05 Mar 2009 13:33:23 +0000 https://forum.productcart.com/cani-use-access-sql_topic2533_post9171.html#9171 <![CDATA[cani use access sql? : hi everyone i was wondering if...]]> https://forum.productcart.com/cani-use-access-sql_topic2533_post9170.html#9170 Author: a3dcreator
Subject: 2533
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.
]]> Thu, 05 Mar 2009 13:19:59 +0000 https://forum.productcart.com/cani-use-access-sql_topic2533_post9170.html#9170