Web Wiz Support and Community Forums : Access v MSSQL When to make the change https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 12:03:39 +0000 Wed, 21 Jul 2004 22:09:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=1535 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access v MSSQL When to make the change : While I agree with -borg- about...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62148.html#62148 Author: xeerex
Subject: 1535
Posted: 21 July 2004 at 10:09pm

While I agree with -borg- about scalability and performance of MSSQL,access can do ok with web usage depending on the setup. Here are thestats from my largest board running Access:

Launch Date of Site: February 4th, 2004 (167 days of operation)
We have 3792 Posts in 586 Topics in 17 Forum(s)
Avg Posts Per Day: 22.71

We have 9493 Forum Members
Avg New Members per day: 56.52 (excluding today)
New Members today (so far): 54 | Yesterday: 39
# of Members Visiting Site Today: 831 (excluding new members)

The main thing with Access is the concurrent connections whichcan overstress a server. However, again, mine averages greater that 20users in the Active users stats and has peaked at 150 before. Here isthe current:

There are currently 47 Active Users online, 22 Guest(s) and 25 Member(s)

Anyway, MS SQL is the best way to go as soon as you can upgrade;however, with the right setup, access isn't too bad especially withsuch a well-designed forum.

ps: here's the link to see for yourself and see how quickly mine runs

http://www.rexpage.com/myseq/forum

You can login as test:test if you like.
]]> Wed, 21 Jul 2004 22:09:06 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62148.html#62148 <![CDATA[Access v MSSQL When to make the change : Som time you will be force to...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62121.html#62121 Author: likedon
Subject: 1535
Posted: 21 July 2004 at 8:28am

Som time you will be force to do it, but for speed, the host has much to say: look at one I have going here:

http://thegreenpride.dk/forum7/default.asp

I think it runs well, and it's the Access version and the size is 25MB

But I will tell you if I knew then what I know now, it would have been the SQL version.

]]> Wed, 21 Jul 2004 08:28:32 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62121.html#62121 <![CDATA[Access v MSSQL When to make the change : Looking back i do regret not using...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62117.html#62117 Author: Rebel Gaa
Subject: 1535
Posted: 21 July 2004 at 7:32am

Looking back i do regret not using the SQL version from the start, would be alot less hassle. However i have used now. With the information i supplied, should i upgrade or would it be ok waiting for another while?]]> Wed, 21 Jul 2004 07:32:18 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62117.html#62117 <![CDATA[Access v MSSQL When to make the change : The MS SQL Server version will...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62114.html#62114 Author: WebWiz-Bruce
Subject: 1535
Posted: 21 July 2004 at 6:05am

The MS SQL Server version will always give better performance.

I would recommend using the MS SQL Server version from the start aschanging databases is never an simple task and Access was neverdesigned as a web site database system and uses allot of web serverresources giving ALLOT of problems.
]]> Wed, 21 Jul 2004 06:05:26 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62114.html#62114 <![CDATA[Access v MSSQL When to make the change : Hi, I waswondering if anyone...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62113.html#62113 Author: Rebel Gaa
Subject: 1535
Posted: 21 July 2004 at 5:50am

Hi,

I was wondering if anyone could help me. I am currently running version 7.9 Access forum. I'm trying to decide whether to change to SQL forum or not or if i need to. The following are my forum stats:

Number of Forums: 11
Number of Topics: 759
Number of Posts: 11157
Number of Members: 1044
Number of PM's: 511
Number of Polls: 24
Number of User Groups: 7

Anyone have any advice for me?

 

]]> Wed, 21 Jul 2004 05:50:29 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post62113.html#62113 <![CDATA[Access v MSSQL When to make the change : Access is a front end/IDE/distibution...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55621.html#55621 Author: dpyers
Subject: 1535
Posted: 29 April 2004 at 12:33pm

Access is a front end/IDE/distibution environment  for a data base engine. People tend to call the data base Access. The current data base used by access is Jet. It's one of many data base engines Access has been bundled with over the years.

Jet is very good for small workgroup applications built around LANs. However, it doesn't scale well for internet use. For LANs, once the capabilities of Jet are outgrown, it's a pretty good leap to MS SQL Server for most small companies.

Microsoft is phasing out the Jet Engine. Future versions of Access will be released with MSDE (MS SQL "Light"). You can use Access today to build and run applications with MSDE as the DB. The problems (IMHO) however, are that the SQL supported by Access is not optimized for the SQL supported by MSDE/MSSQL, and that the distibution methods to employ an Access/MSDE solution are cumbersome and eror prone.

 

]]> Thu, 29 Apr 2004 12:33:31 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55621.html#55621 <![CDATA[Access v MSSQL When to make the change : I have never known what the fuss...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55601.html#55601 Author: fbridge2
Subject: 1535
Posted: 29 April 2004 at 11:01am

I have never known what the fuss is about Access. Loading a 30MB file into 2GB memory doesn't seem too much of a task for a dual processor machine.

I have used Access since Access97 and upgraded as and when and have saved absolutely thousands of pounds for my company. I wouldn't use it for a high transaction site but for info gathering, issuing and generl tasks it has to be the best thing that MS bought.

Regards
Frank

]]> Thu, 29 Apr 2004 11:01:31 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55601.html#55601 <![CDATA[Access v MSSQL When to make the change : u kidin only 50mb ur db ? mine...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55522.html#55522 Author: zadax
Subject: 1535
Posted: 28 April 2004 at 3:25pm

u kidin only 50mb ur db ? mine 1000mb+ and i m trying to upgrade for week now but keep geting errors and stuff :(

my qustion/problem is  :

i cleard the old topics and stuff ..  i compect and fix it and now my db 60mb.

now i am trying to do the Upsizing thing and it works for over 5 hours now

thats how it works ?

(ppl who can come help me little in chat /msn/icq plz send me pm  )

]]> Wed, 28 Apr 2004 15:25:47 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post55522.html#55522 <![CDATA[Access v MSSQL When to make the change : Have a look atMSACCES, MSSQL,...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post10100.html#10100 Author: hans3702
Subject: 1535
Posted: 27 April 2003 at 6:15am

Have a look at MSACCES, MSSQL, MYSQL before upgrading

 

]]> Sun, 27 Apr 2003 06:15:24 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post10100.html#10100 <![CDATA[Access v MSSQL When to make the change : From memory, when you use the...]]> https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post7529.html#7529 Author: Bunce
Subject: 1535
Posted: 06 April 2003 at 9:16pm

From memory, when you use the upsizing wizard, it does not always copy across the primary and foreign keys (ie, your relationships).

After you create the tables in SQL, you might need to go through and re-assign your keys.

Then insert the data.

Then go through the necessary columns and make those that were 'autonumbers' in Access, Identity fields in SQL Server.

This was an issue a few years ago anyway. MS released an office update called the 'Access 2000 upgrade to SQL Server 2000 Readiness Update" or something similar, so make sure you have that first.

Cheers,
Andrew



Edited by Bunce]]> Sun, 06 Apr 2003 21:16:23 +0000 https://forums.webwiz.net/access-v-mssql-when-to-make-the-change_topic1535_post7529.html#7529