Web Wiz Forums - Access Vs MS SQL

Print Page | Close Window

Access Vs MS SQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11986
Printed Date: 09 April 2026 at 4:44am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access Vs MS SQL

Posted By: jeeproject
Subject: Access Vs MS SQL
Date Posted: 29 September 2004 at 1:06pm

I am starting an online forum and was wondering what differences or advantages are between Access and MS SQL. I am familiar with Access but have never used MS SQL.

I already have Access 2003. If I was to use MS SQL how much would it cost?

If I start the forum with Access is there anyway to convert the database to MS SQL later on?

Replies:

Posted By: michael
Date Posted: 29 September 2004 at 1:07pm

Please do a search, this has been discussed plenty of times.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: kbannon
Date Posted: 30 September 2004 at 6:57pm

jeeproject wrote:

I am starting an online forum and was wondering what differences or advantages are between Access and MS SQL. I am familiar with Access but have never used MS SQL.

Access is fine for small forums where user traffic will not be heavy.

jeeproject wrote:

I already have Access 2003. If I was to use MS SQL how much would it cost?

How long is a piece of string?

jeeproject wrote:

If I start the forum with Access is there anyway to convert the database to MS SQL later on?

yes. you or your MSSQL host can do it!

-------------
I don't suffer from insanity, I enjoy every minute of it.

Posted By: WebWiz-Bruce
Date Posted: 01 October 2004 at 3:58am

I personally would recommened MS SQL Server everytime as a backend for a forum, no matter what size of forum you have, as Access has to many limitations.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: xeerex
Date Posted: 01 October 2004 at 12:01pm

I agree on starting off with MS SQL Server when in doubt. However, you can also [ http://forums.webwiz.net/forum_posts.asp?TID=11806&get=last#65816 - read my reply ] for some more insight into Access on the same subject, which has been discussed over and over and over.....

-------------
http://webspacegeeks.com - Need Hosting, Domains, Dedicated Servers?
http://www.smartergeek.com - web design | pc support | training | podcasts | video production