Print Page | Close Window

Active Users and Access

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=7212
Printed Date: 04 April 2026 at 8:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Active Users and Access
Posted By: thermonuke
Subject: Active Users and Access
Date Posted: 12 November 2003 at 7:19pm
How much of a risk do i take in corrupting the Access database with "Active Users" activated with a small member load, around 5 on at any time. Your promtp response is appreciated.



Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 November 2003 at 1:59am
I personally would not risk it as all with Access as it just can't cope with the content updates. All it takes is two people updating the database at the same time a your database will become corrupted crashing the entire forum.

Your database will also grow to a larger size than it should be.

I'm planning on looking into using a different way of doing the active users using Application variables to store the details rather than a database so that Access users will be able to use this feature.


-------------
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: futurefiles
Date Posted: 13 November 2003 at 8:52am
i have had active users on for about 5 months now i only have 9 users and there are only 184 posts. im using access and have not experianced any problems with active users being on.


Posted By: eksimba
Date Posted: 13 November 2003 at 3:16pm

I agree with -boRg- in his assessment that the Active Users function places extra stress on an Access database and increases the chance for a database corruption and also increases the database filesize more than if the feature is turned off.

That being said, I have had a forum running on Access with the Active Users function turned on for about 7 months now without a problem. There are just over 80 members, during the day there may be 15-20 concurrent users, and they have posted almost 50,000 posts so far.

I purge older posts from the database periodically, trying to keep the post count at about 10,000 posts, and I compact the database once every week or so. My host does a nightly backup, so if anything catastrophic happens I can restore if need be.



-------------
- eric


Posted By: thermonuke
Date Posted: 13 November 2003 at 6:27pm

Thank you for your prompt replies and advice, Currently I will leave it running and backup the database nightly. Thanks again.



Posted By: Cereval
Date Posted: 13 November 2003 at 9:07pm

Originally posted by thermonuke thermonuke wrote:

How much of a risk do i take in corrupting the Access database with "Active Users" activated with a small member load, around 5 on at any time. Your promtp response is appreciated.

I enabled it and in less than a day ... http://forums.webwiz.net/forum_posts.asp?TID=6723 - it crashed .

Originally posted by <SPAN class=bold>-boRg-</SPAN> -boRg- wrote:

I'm planning on looking into using a different way of doing the active users using Application variables to store the details rather than a database so that Access users will be able to use this feature.

This is very happy news. The one drawback I could ever say of WebWiz is the limitations of this function for Access users. Perl and php forums have seemingly no problems with this feature, across server platforms.

Not to pry, but have you had any progress on it so far ... ? (as you can tell, I'm dying to have this feature work) If so, ball park time before it's finished?



Posted By: WebWiz-Bruce
Date Posted: 14 November 2003 at 1:53am
I wouldn't know as it's whenever I get any spare time to do any coding.

-------------
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: wistex
Date Posted: 15 November 2003 at 10:52am

Could the active users information be stored in another database file?  That way if the active users crashed, it wouldn't bring down the rest of the site.  But then again, active users would be prone to crashing.  So I guess that's not a solution either.

I am so glad I am using the SQL version.



-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net