Dear friends,

well, before explaining my problem, I must say I'm a HUGE fan of WWForum, which I use since last December.

Recently, my forum started to run really slowly. I batch deleted old topics, deleted 400+ registered users that have never posted, but no dice. It's still slow. My forum statistics (after deleting topics and members):

82119 mensagens em 2847 Tópicos em 31 Fórum(s)
Nós temos 1445 Membros do fórum

My database is 142 Mb. I run the MySQL version of the forum. WHen I try compacting the DB, I get the following message:

Database backed up to:-
C:\Inetpub\CinemaCena\forum\admin\database\ccForum-backup.md b

Microsoft JET Database Engine error '80004005'

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

/cinemacena/forum/admin/compact_access_db.asp, line 124

What can I do???

Definitely time to go to SQL Server!

As a side note, I run an Access version that is currently at ~13MB with 7500+ users averaging over 25 active users at any one time. Page returns are generally less than .5 seconds; however, I had to work with my host to get my board to run that fast with that many connections to Access. At peak times, there will be over 100 active users showing and page returns are still less than 1 second.

I have noticed that when I use the Admin Compact/Repair it will error on the first try. I have to FTP into the site, delete the temp databases that are created, and then the C/R will work fine. Of course, I close the forum, and I could download the database and "manually" C/R; however, I make a daily backup of the database to my local computer anyway so any lose would not be that great.

the way to tell if you are using an access version or an SQL version is 2 ways

1. have you got a database which you dont require a username and password to conect to (if so you are using an Access database),

did you have to run the page (msSQL_server_setup.asp)? if so you are running an SQL version

2. Go into the admin area and if you are running the SQL version in the menu you will be able to go to a page that gives some SQL server details like the size of the SQL database and the log file. if so you are using an SQL version.

dpyers wrote: Try locking the forum before doing an Access compact and repair. Sound's like there may be activity updating the ldb file which has been known to cause a C&R to fail and lock things up.

That worked like a charm. :)

Thanks!

xeerex wrote: Of course, I close the forum,...

Sorry but I thought that was obvious.

One thing to consider is that even by locking the forum, the database still gets a connection each time someone hits the board since the lock is using the database. I understand the administrative ease and reason that -borg- has the lock in the database; however, on really active boards you may consider using a script that will "lock" users and redirect them without using a database connection.

For instance, I created a "lock.asp" file and just include it in any pages that may make a database connection. I manually change the page to "locked" and FTP it to the site. I make all necessary changes, "unlock" the page, and FTP it up again.

<%
'Lock access to the Admin Module

strLocked = "No"  'Change this to yes or no
If strLocked = "Yes" Then
 Response.Redirect("Lock_Message.asp")
End If
%>