Hi.

I think I messed up the database a little. Can't figure what's wrong there.

Here's my problem. When the script gets to this query (in active_users.inc file):

'Clean up old users
'Initilse sql statement
If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE wwfSpDeleteActiveUser"
Else
 strSQL = "DELETE FROM tblActiveUser WHERE tblActiveUser.Active < Now() - 0.0070;"
End If

'Detlete from database
adoCon.Execute(strSQL)

When the query is executed I'm getting this:

Microsoft JET Database Engine error '80004005'

The search key was not found in any record.

/forum/active_users.inc, line 196

So I temporarily commented the Execute statement out.

What's could be wrong? Please help.

I think that the DB has become corrupted.

I ran the Compact and repair and it fixed it.

Can you tell me why this had happened?

It's Access with about 950 members.

Access sometimes has problems with the amount of updates needed for the active users feature.

If you are running version 7 then you can disable the active users feature from the admin area, if you are running version 6.x then it will probally be worth upgrading in a few weeks when the full version of version 7 is released and disabling the active users feature to prevent this form happening again.