Print Page | Close Window

Active Users List

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=6772
Printed Date: 03 April 2026 at 11:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Active Users List
Posted By: Cereval
Subject: Active Users List
Date Posted: 28 October 2003 at 1:19am

Quote Active Users List
Users of Access versions of the forum DO NOT enable this feature as Access can not cope with the updates required and may lead to the database becoming corrupted and unrecoverable losing all your posts and data!

Well ... I qualify as a user of Access ... so how can I have this feature work?

(In an earlier post I mentioned that I risked it and failed - the board crashed.)




Replies:
Posted By: WebWiz-Bruce
Date Posted: 28 October 2003 at 1:27am
You can't unless you upgrade to SQL server.

To keep track of active users there details are stored in a database table this needs to be constently updated as people move around the forum. The problem then comes with Access, as a flat file database system it can only cope with so many people connecting to it at once, it two people try updating the database at the same time problems occur. You also have the other problem that access doesn't completly remove entries from the database after they are deleted until a compact and repair is done, this then leads to your database file getting larger than it should and slowing down performance.


-------------
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: 28 October 2003 at 11:37pm

Yeah, that is the problem with using MS Access.  MS Access is a great way to get started without shelling out money for a SQL Database, but if your site grows in popularity, SQL is really the only way to go.

If your site doesn't become popular, then you saved money by not paying for SQL.  And if your site becomes popular, expect to upgrade to SQL to handle the demand caused by being popular.



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


Posted By: Cereval
Date Posted: 29 October 2003 at 1:34am
Originally posted by wistex wistex wrote:

Yeah, that is the problem with using MS Access.  MS Access is a great way to get started without shelling out money for a SQL Database, but if your site grows in popularity, SQL is really the only way to go.

If your site doesn't become popular, then you saved money by not paying for SQL.  And if your site becomes popular, expect to upgrade to SQL to handle the demand caused by being popular.

If I upgraded, would I need to change anything as far as settings or configuration? Or could I leave everything as is?



Posted By: Cereval
Date Posted: 31 October 2003 at 1:22am

Originally posted by -boRg- -boRg- wrote:

You can't unless you upgrade to SQL server.

To keep track of active users there details are stored in a database table this needs to be constently updated as people move around the forum. The problem then comes with Access, as a flat file database system it can only cope with so many people connecting to it at once, it two people try updating the database at the same time problems occur. You also have the other problem that access doesn't completly remove entries from the database after they are deleted until a compact and repair is done, this then leads to your database file getting larger than it should and slowing down performance.

I noticed that someone commented in the mods forum that they are using Access and an Active Users mod ( http://forums.webwiz.net/forum_posts.asp?TID=2941&PN=1&TPN=5 - See Michelle's comment ). Now, if the standard feature won't work, does that mean that this mod won't work either?



Posted By: WebWiz-Bruce
Date Posted: 31 October 2003 at 4:48am
If it uses an access database to store the data it will suffer from the same problem.

The only work around is to store the data somewhere else like an array at application level or the dictionary object.


-------------
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: Cereval
Date Posted: 31 October 2003 at 10:14am

Originally posted by -boRg- -boRg- wrote:

If it uses an access database to store the data it will suffer from the same problem.

The only work around is to store the data somewhere else like an array at application level or the dictionary object.

If I upgrade to MySQL, will the database start anew? Or will everything as is and pick up where it left off?



Posted By: WebWiz-Bruce
Date Posted: 31 October 2003 at 10:27am
The forum only works with Access and MS SQL Server 2000, it doesn't work with mySQL.

-------------
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: 01 November 2003 at 11:56am

I got WWF 7.01 to run on SQL 7.0.  Not sure if WWF 7.5 will run on SQL 7.0, but I'm already upgraded to SQL 2000 so....



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


Posted By: Cereval
Date Posted: 03 November 2003 at 11:12am

This may sound far-fetched but please forgive this WebWiz newbie ...

Is it possible to make a mod for us Access users that displays Active Users?

My server runs on Access. I can upgrade to MySQL. But then I found out that MySQL will not work with this forum. And then I also found out that MS SQL costs as much monthly as my current plan yearly ...

... advice?




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