Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Compact & Repair DB Error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Compact & Repair DB Error
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Rebel Gaa View Drop Down
Groupie
Groupie


Joined: 04 September 2003
Location: Ireland
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Rebel Gaa Quote  Post ReplyReply Direct Link To This Post Topic: Compact & Repair DB Error
    Posted: 06 August 2004 at 7:03pm

Hi,

I try to "Compact & Repair" my access database forum and i get the following error.

Microsoft VBScript runtime error '800a0035'

File not found

/forum/admin/compact_access_db.asp, line 110

I have tried in replacing the specified file but get the same error. The file is in the correct directory. I am running the latest version, 7.9.

Anyone got any ideas of my problem and how it can be fixed?

Thanks
Back to Top
Rebel Gaa View Drop Down
Groupie
Groupie


Joined: 04 September 2003
Location: Ireland
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Rebel Gaa Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 4:00am
Anyone have any ideas about my problem?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 4:27am
Many hosts disable parts of the FSO object for security reasons, this means that the compact and repair feature will not run on all servers. Your site must be on one of these servers.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Rebel Gaa View Drop Down
Groupie
Groupie


Joined: 04 September 2003
Location: Ireland
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Rebel Gaa Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 7:12am
Alright boRG, thanks for the information, appreciate it. Will download the database, compact and repair it and then upload it again. Would that do the trick and is it safe?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 9:09am
That will do exactly the same thing as the on-line version
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 12:10pm

Probably a good idea to shutdown the forum from the admin panel before downloading so people who make posts to the forum won't loose them when the compacted data base is uploaded.

 When you re-upload the .mdb. delete any existing .ldb file on your web server.
The .ldb is a temporary file that tracks who is where, doing what on your data base. The existing one will not line up with a newly compacted .mdb file. Normally the .ldb file is deleted when a db is shut down, but sometimes not.

 

Lead me not into temptation... I know the short cut, follow me.
Back to Top
polecat View Drop Down
Groupie
Groupie


Joined: 14 April 2004
Location: Argentina
Status: Offline
Points: 131 		Post Options Post Options   Thanks (0) Thanks(0)   Quote polecat Quote  Post ReplyReply Direct Link To This Post Posted: 09 August 2004 at 6:57pm
I have a question...if you download the database to make a backup, and while you are downloading the database, there are active users in your forum....that will be a problem?
I must backup the database when there's no active users in the forum? Or it doesn't matter?
ÞأˢÂT

Rataforo - Rata Blanca forums
Mi personal website
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.