Web Wiz Support and Community Forums : Active Users List https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 23:16:02 +0000 Mon, 03 Nov 2003 11:12:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=6772 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Active Users List : This may sound far-fetched but...]]> https://forums.webwiz.net/active-users-list_topic6772_post34504.html#34504 Author: Cereval
Subject: 6772
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?

]]> Mon, 03 Nov 2003 11:12:37 +0000 https://forums.webwiz.net/active-users-list_topic6772_post34504.html#34504 <![CDATA[Active Users List : I got WWF 7.01 to run on SQL 7.0....]]> https://forums.webwiz.net/active-users-list_topic6772_post34161.html#34161 Author: wistex
Subject: 6772
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....

]]> Sat, 01 Nov 2003 11:56:54 +0000 https://forums.webwiz.net/active-users-list_topic6772_post34161.html#34161 <![CDATA[Active Users List : The forum only works with Access...]]> https://forums.webwiz.net/active-users-list_topic6772_post33994.html#33994 Author: WebWiz-Bruce
Subject: 6772
Posted: 31 October 2003 at 10:27am

The forum only works with Access and MS SQL Server 2000, it doesn't work with mySQL.]]> Fri, 31 Oct 2003 10:27:06 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33994.html#33994 <![CDATA[Active Users List : -boRg- wrote:If it uses an...]]> https://forums.webwiz.net/active-users-list_topic6772_post33992.html#33992 Author: Cereval
Subject: 6772
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?

]]> Fri, 31 Oct 2003 10:14:55 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33992.html#33992 <![CDATA[Active Users List : If it uses an access database...]]> https://forums.webwiz.net/active-users-list_topic6772_post33931.html#33931 Author: WebWiz-Bruce
Subject: 6772
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.
]]> Fri, 31 Oct 2003 04:48:41 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33931.html#33931 <![CDATA[Active Users List : -boRg- wrote:You can&#039;t...]]> https://forums.webwiz.net/active-users-list_topic6772_post33914.html#33914 Author: Cereval
Subject: 6772
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 (See Michelle's comment). Now, if the standard feature won't work, does that mean that this mod won't work either?

]]> Fri, 31 Oct 2003 01:22:14 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33914.html#33914 <![CDATA[Active Users List : wistex wrote: Yeah, that is...]]> https://forums.webwiz.net/active-users-list_topic6772_post33468.html#33468 Author: Cereval
Subject: 6772
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?

]]> Wed, 29 Oct 2003 01:34:55 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33468.html#33468 <![CDATA[Active Users List : Yeah, that is the problem with...]]> https://forums.webwiz.net/active-users-list_topic6772_post33465.html#33465 Author: wistex
Subject: 6772
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.

]]> Tue, 28 Oct 2003 23:37:22 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33465.html#33465 <![CDATA[Active Users List : You can&#039;t unless you upgrade...]]> https://forums.webwiz.net/active-users-list_topic6772_post33308.html#33308 Author: WebWiz-Bruce
Subject: 6772
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 databasetable this needs to be constently updated as people move around theforum. The problem then comes with Access, as a flat file databasesystem it can only cope with so many people connecting to it at once,it two people try updating the database at the same time problemsoccur. You also have the other problem that access doesn't completlyremove entries from the database after they are deleted until a compactand repair is done, this then leads to your database file gettinglarger than it should and slowing down performance.
]]> Tue, 28 Oct 2003 01:27:30 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33308.html#33308 <![CDATA[Active Users List : Active Users ListUsers of Access...]]> https://forums.webwiz.net/active-users-list_topic6772_post33306.html#33306 Author: Cereval
Subject: 6772
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.)

]]> Tue, 28 Oct 2003 01:19:33 +0000 https://forums.webwiz.net/active-users-list_topic6772_post33306.html#33306