Print Page | Close Window

New DB Errors

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=9073
Printed Date: 07 April 2026 at 4:55pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: New DB Errors
Posted By: JfHideout
Subject: New DB Errors
Date Posted: 20 January 2004 at 12:57pm

I've had to move the database since I installed it last week (and with your help migrated my users to it. Thank you!). I'm not getting two different errors regularly at different times...

There's this one...

Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/forum/common.asp, line 260

 

And this...

Active Server Pages error 'ASP 0113'

Script timed out

/forum/default.asp

The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

Now the first one, I have NO idea why it's doing it. I've given the db file read/write permissions, nothing else would be using the file... I just don't know what the problem could really be. I also compacted and repaired it and that hasn't helped... I assume the second error is just host related, but I don't understand why the forum has become suuuper slow (probably also server related). But the page also works *sometimes* before I get the 80004005 error again. It's really inconsistent... Can you guys help at all before I intentionally ram my head into a stud in the wall? Thank you




Replies:
Posted By: Semikolon
Date Posted: 20 January 2004 at 1:08pm

the first one is because the script cannot execute the database connection, because the file may be in use or something.. but im not really sure about that one..

 

the second one is either corrupt files or a slow server.. myself i got that error on the admin nag screen, witch contains almost no script at all.. between 8am and 5pm(office time) the servers have truckloads of visitors....

 

so i think you should talk with your host.. about both problems..



Posted By: Eftie
Date Posted: 20 January 2004 at 1:23pm

First one I got when there were not sufficient write permissions on the database. The ASP scripts could not delete the .ldb file which cause Access to think the file is in use.

Verify write access all the way to the database.



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


Posted By: JfHideout
Date Posted: 20 January 2004 at 1:53pm

Anthrax, thanks for the input...
Yeah, it's a new host and I've mentioned both errors which they don't seem to understand or know how to fix...

Eftie, I've made sure the db has read/write permissions several times. Do you think I need to make sure the whole folder has it?

Thanks for your input guys, I really appreciate it. hopefully i can figure this out asap... 



Posted By: Semikolon
Date Posted: 20 January 2004 at 2:02pm

try reupload the files, if you still get the script timeout error, tell your host to have a f**king look at the load of the server.. errors like that appears only when you have bad code, or the server is to heavy loaded..

the first one is because the database is in use.. you are using access right? check if there is, like Eftie said, a .ldb file in the folder where your database is located.. if its not, try upload a clean database and try run the script.. it that wont work, tell your host to have another f**king look at the server.. cuz then it have to be a server problem..

you should also have read and write access to the folder, but in this case, thats not the problem..



Posted By: dpyers
Date Posted: 20 January 2004 at 6:49pm
If you upload a new .mdb file, delete the old .ldb file.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: JfHideout
Date Posted: 20 January 2004 at 6:53pm
There is no .ldb file


Posted By: Semikolon
Date Posted: 21 January 2004 at 10:09am
try upload a clean copy of the forum in another folder and try run it.. if it wont work, then you should really talk with your host.. or maybe change host if they dont understand..


Posted By: JfHideout
Date Posted: 21 January 2004 at 12:22pm

Thanks Anthrax...

Yeah, I reinstalled it and it seemed to work great. But all my users and posts are in the other db file. So I saved the new db as a backup file and reuploaded the old db and it seemed to run smoothly. I'm on a different computer today and I'm now getting a "Not Updatable Query" error. I made sure the db folder and the db both have read & write permissions, so I don't know what's up. Also, I deleted the new .ldb file but it keeps coming back up. If that file's a problem, how can I make sure it doesn't keep coming back?

Thanks guys. By the way, the forum link is http://www.jesusfreakhideout.com/forum - here .

 



Posted By: JfHideout
Date Posted: 21 January 2004 at 12:24pm
Ha, AND I'm still getting...

Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/forum/common.asp, line 260

Is there a way I can use a new db with my current info from it? Y'know what I mean?



Posted By: Semikolon
Date Posted: 21 January 2004 at 12:47pm

so it was a .ldb file in your database folder? and after you deleted it it came back?

if thats the case, then it has to be the server.. no doubt.. go talk with your host..



Posted By: WebWiz-Bruce
Date Posted: 21 January 2004 at 1:06pm
It does mean a server issue, get your hosts to look into it.

-------------
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: JfHideout
Date Posted: 21 January 2004 at 1:12pm
OK, I emailed them. In case they happen to be clueless to it, do you know what I can ask them to look for / fix? (Thanks guys. Seriously, I really appreciate your help and input)


Posted By: dpyers
Date Posted: 21 January 2004 at 10:33pm
Originally posted by JfHideout JfHideout wrote:

Also, I deleted the new .ldb file but it keeps coming back up. If that file's a problem, how can I make sure it doesn't keep coming back?

The ldb file is created whenever the mdb file is opened. It tracks what users have locked what records for updating, and a few other things.

It's supposed to be deleted whnever the last user closes the db (one of the reasons why you have to have IUSR delete access to the directory you have your access db in), but sometimes it doesn't get deleted. If there's been some db corruption or some other error, it doesn't get deleted. An some times it doesn't get deleted just for the hell of it!

Any time you make a change to a table on an access db, you should delete any old ldb files when you upload it because it won'y line up with the new db format.



-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: JfHideout
Date Posted: 23 January 2004 at 1:40pm

Thanks for your tips guys. Looks like our server guys fixed it.

One last question though... Everything seems to be running pretty good except the boards alone are pretty slow and we're getting a couple complaints that people can't log in. I went into the admin and reset permissions for the member groups a couple times and even reset the permissions for certain members and they're still getting an error that says they have no permissions. In fact, after I reset permissions to give ME all the permissions to edit other's info, it says I don't have permission to change it. Any ideas? :~/ 

Thanks once again guys! You guys are great



Posted By: dpyers
Date Posted: 23 January 2004 at 6:41pm

Personally, I paint Bill Gates face on a goat and sacrifice it when there's a full moon in the Eastern sky. Seems to please the server gods.

Is the error a forum error or a system level error like you posted above? If a forum error, you may want to clear out all cookies and restart the browser.



-------------

Lead me not into temptation... I know the short cut, follow me.



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