| Author |
Topic Search Topic Options
|
JfHideout
Newbie
Joined: 12 January 2004
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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 here.
|
 |
JfHideout
Newbie
Joined: 12 January 2004
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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?
|
 |
Semikolon
Senior Member
Joined: 09 September 2003
Location: Norway
Status: Offline
Points: 1718
|
Post Options
Thanks(0)
Quote Reply
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..
|
 |
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 January 2004 at 1:06pm |
|
It does mean a server issue, get your hosts to look into it.
|
|
|
 |
JfHideout
Newbie
Joined: 12 January 2004
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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)
|
 |
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 January 2004 at 10:33pm |
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.
|
 |
JfHideout
Newbie
Joined: 12 January 2004
Status: Offline
Points: 12
|
Post Options
Thanks(0)
Quote Reply
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
|
 |
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
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.
|
 |