| Author |
 Topic Search  Topic Options
|
FLATLINE 
Groupie
Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Need URGENT Help!!! Seriously!
Posted: 20 October 2003 at 4:07pm |
I keep getting this error when accessing forum pages:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.
/forum/includes/active_users_inc.asp, line 147
The problem is with this line: (143)
strSQL = "DELETE FROM " & strDbTable & "ActiveUser WHERE " & strDbTable & "ActiveUser.Active < Now() - 0.0070;"
There's something in the "Now() - 0.0070" that causes the problem, but I can't figure out what's the problem, nothing that I do helps! Please help me this is stopping from my whole site to work because WWF is my backend! 
Edited by FLATLINE
|
|
|
 |
FLATLINE
Groupie
Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 October 2003 at 4:50pm |
|
|
|
|
|
God_Struth
Senior Member
Joined: 07 August 2003
Location: United Kingdom
Status: Offline
Points: 218
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 October 2003 at 4:53pm |
|
Go into the database and disable active users and that should solve it short term. Otherwise, I think that is a corruption error of sorts, I may be mistaken, but you should do a compact and repair on it.
|
|
"I'm only trying to help......"
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 October 2003 at 6:58am |
|
The error means that your access database is corrupted and needs to be
compacted and repair, you can do this in the admin area in version 7.5
or download the database and do it in MS access in older versions.
This problem can and will happen again unless you turn off the active
users feature in the Access version as Access can NOT cope with the
number of updates required!!!
|
|
|
|
wistex
Mod Builder Group
Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 October 2003 at 7:49pm |
If your site is really busy, it might be worth it to upgrade to a SQL database. It costs more, but it was designed to be used on the internet with a lot of traffic. Access was designed for use on PCs and can't handle the same amount of traffic without getting bogged down.
Access may be a good and cheap way to start out, but if your site gets really really big, you need SQL.
|
|
|
|
nickg
Mod Builder Group
Joined: 06 August 2003
Location: France
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 8:40am |
 -boRg- wrote:
The error This problem can and will happen again unless you turn off the active
users feature in the Access version as Access can NOT cope with the number of updates required!!!
|
Just for information, how to do this in access version?
@+
Edited by nickg
|
|
FLATLINE
Groupie
Joined: 08 July 2002
Location: Israel
Status: Offline
Points: 142
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 10:57am |
Thanks for the help. I've disabled the active users for now.
Borg, when I try to compact and repair the database from the admin menu, I get the following message:
-
Database backed up to:-
<path to database (censored)>
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/forum/admin/compact_access_db.asp, line 124
|
|
|
|
Str8Dog
Senior Member
Joined: 18 December 2001
Location: United States
Status: Offline
Points: 2118
|
Post Options
Thanks(0)
Quote Reply
Posted: 24 October 2003 at 12:03pm |
|
flatline download the database and do it with access.
|
|
|
|
