Web Wiz Support and Community Forums : Active Users and Access https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 06:43:36 +0000 Sat, 15 Nov 2003 10:52:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7212 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Active Users and Access : Could the active users information...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36388.html#36388 Author: wistex
Subject: 7212
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.

]]> Sat, 15 Nov 2003 10:52:47 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36388.html#36388 <![CDATA[Active Users and Access : I wouldn&#039;t know as it&#039;s...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36218.html#36218 Author: WebWiz-Bruce
Subject: 7212
Posted: 14 November 2003 at 1:53am

I wouldn't know as it's whenever I get any spare time to do any coding.]]> Fri, 14 Nov 2003 01:53:34 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36218.html#36218 <![CDATA[Active Users and Access : thermonuke wrote:How much of...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36199.html#36199 Author: Cereval
Subject: 7212
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 ... 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?

]]> Thu, 13 Nov 2003 21:07:37 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36199.html#36199 <![CDATA[Active Users and Access : Thank you for your prompt replies...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36181.html#36181 Author: thermonuke
Subject: 7212
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.



Edited by thermonuke]]> Thu, 13 Nov 2003 18:27:35 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36181.html#36181 <![CDATA[Active Users and Access : I agree with -boRg- in his assessment...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36162.html#36162 Author: eksimba
Subject: 7212
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.

]]> Thu, 13 Nov 2003 15:16:00 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36162.html#36162 <![CDATA[Active Users and Access : i have had active users on for...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36100.html#36100 Author: futurefiles
Subject: 7212
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.]]> Thu, 13 Nov 2003 08:52:51 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36100.html#36100 <![CDATA[Active Users and Access : I personally would not risk it...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36051.html#36051 Author: WebWiz-Bruce
Subject: 7212
Posted: 13 November 2003 at 1:59am

I personally would not risk it as all with Access as it just can't copewith the content updates. All it takes is two people updating thedatabase at the same time a your database will become corruptedcrashing 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 activeusers using Application variables to store the details rather than adatabase so that Access users will be able to use this feature.
]]> Thu, 13 Nov 2003 01:59:43 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36051.html#36051 <![CDATA[Active Users and Access : How much of a risk do i take in...]]> https://forums.webwiz.net/active-users-and-access_topic7212_post36025.html#36025 Author: thermonuke
Subject: 7212
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.

Edited by thermonuke]]> Wed, 12 Nov 2003 19:19:48 +0000 https://forums.webwiz.net/active-users-and-access_topic7212_post36025.html#36025