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) 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
Just for information, how to do this in access version? @+ |
-boRg- wrote: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:
------------- 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 : After activating : ------------- Eftie |