11-28-11, 21:40 #1Registered User
- Join Date
- Nov 2011
Unanswered: I want to use Access Database for a Subscription based web site
I am creating a Subscription based web site. It's in ASP with Access Database. However, many online posts/reviews recommand NOT to use Access Database as it's primary use only for desktop applications not server side.
Some of the posts mentioned that Access can't handle more than 255 users accessing at the same time. I am guessing, the web site i am creating, will going to have only 20-50 users at one time. If it's out grow, i can always move to MSSQL Server.
So the question is, what do you guys recommand? Should i use Access Database or not? I am very comfortable working with ASP with Access Database. I am creating this web site since 3 weeks and everything has been working very smooth as of now.
11-29-11, 03:22 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
For a mark 1 version you could use msacess as the backend change that feild to a memo field that fix that problem
If you can jump to MsSQL then just jump in feet first and see what happen lolhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON