| Author |
 Topic Search  Topic Options
|
Routhg 
Newbie
Joined: 17 April 2003
Location: United States
Status: Offline
Points: 26
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Active users -- why not?
Posted: 07 June 2003 at 7:28pm |
The configuration page recommends against Access Web Wiz Forums users turning on the Active Users function. Is it a problem with ALL Access forums, or is it only a problem with lots of users?
My site is a very specialized site, not of interest to the general public, so I don't get a lots of people on the forum at one time. So, if it is a problem only for forums (and Access databases) when there are a lot of users, I would like to turn it on.
Whadda you say? Thanks.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 1:00am |
|
If using the Access version you are best keeping it off as even quite boards can end up with corrupted databases, it also leads to an over large size access database as when a record is deleted from access it still stores some of the data so your database size will just keep growing.
|
|
|
|
DaveHope
Newbie
Joined: 19 August 2002
Location: United Kingdom
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 3:19am |
Borg, just reading this message made be think of something. Why not add an option to compact the access database? It'd solve one of the many problems with using Access databases. I have a script to compact them using MSDAC & ASP, so, if you want some info on how it's done then just ask 
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 4:39am |
I have already added this in the admin section for the next version of the forum.
The only problem is that if the database is corrupted then you won't be able to enter the admin section in order to use this function, but it will be useful for shrinking the zsize of the db online.
|
|
|
|
DaveHope
Newbie
Joined: 19 August 2002
Location: United Kingdom
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 5:41am |
Ok, I guess I was a lil slow at thinking of it 
|
|
blueangel
Newbie
Joined: 09 May 2003
Location: United States
Status: Offline
Points: 32
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 8:05am |
Is this applicable to v6.34 too? As far as the active users.....I didn't start seeing talk about it until v7 came out. Is the DB structure differently? Or is this just as much a problem in v6.34
Kita
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 8:25am |
It is just as much a problem in version 6.34 but there is no option to disable it in version 6.x
The option to disable it was placed in version 7 after many people where having problems with version 6.x with corrupted databases and overly large access database sizes.
|
|
|
|
Routhg
Newbie
Joined: 17 April 2003
Location: United States
Status: Offline
Points: 26
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 June 2003 at 9:03am |
-boRg-,
A corrupted database is reason enough for me to not enable that function, although it sure is a 'nice to have.' What corrupts the database? Is the only solution to get away from Access?
Thanks for the as-always great advice.
|
|
