Print Page | Close Window

Need URGENT Help!!! Seriously!

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6591
Printed Date: 04 April 2026 at 2:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Need URGENT Help!!! Seriously!
Posted By: FLATLINE
Subject: Need URGENT Help!!! Seriously!
Date 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!



-------------
Visit my site: http://darkgreen.service-club.net - DarkGreen HQ



Replies:
Posted By: FLATLINE
Date Posted: 20 October 2003 at 4:50pm

goddamnit! Looks like I found a really bad time to have a serious error! No one's active!!

sh*t, I have a 3-day field trip tomorrow, and looks like my site is gonna be down all that time.



-------------
Visit my site: http://darkgreen.service-club.net - DarkGreen HQ


Posted By: God_Struth
Date 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......"


Posted By: WebWiz-Bruce
Date 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!!!


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: wistex
Date 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.



-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums


Posted By: nickg
Date Posted: 24 October 2003 at 8:40am
Originally posted by -boRg- -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?
@+


Posted By: FLATLINE
Date 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



-------------
Visit my site: http://darkgreen.service-club.net - DarkGreen HQ


Posted By: Str8Dog
Date Posted: 24 October 2003 at 12:03pm
flatline download the database and do it with access.

-------------
http://www.str8dog.com/ - [IMG - http://www.str8dog.com/images/str8dog.gif -
I wasn't born with enough middle fingers.


Posted By: FLATLINE
Date Posted: 24 October 2003 at 5:14pm

Finally! Thank you Str8Dog and everyone else who helped! The active users is finally working. Thanks again!

Well now that we have the error finally fixed, maybe we'll try to understand why it appeared in the first place??



-------------
Visit my site: http://darkgreen.service-club.net - DarkGreen HQ


Posted By: Eftie
Date Posted: 11 November 2003 at 6:03am

Hi Flatline,

I got the same error :
Appearantly it had to do with the fact that this const was blank in admin\common.asp:
strDbPathAndName = "H:\www\Forum751.mdb" 'Use this if you use the physical server path, eg:- C:\Inetpub\private\WebWizForum.mdb

After activating :
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName 'This one is for Access 2000/2002
in the admin\common.asp file it worked really fine! ( tnx -boRg- )



-------------
Eftie



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net