Print Page | Close Window

Compacting Database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17691
Printed Date: 31 March 2026 at 1:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Compacting Database
Posted By: AlanP
Subject: Compacting Database
Date Posted: 31 December 2005 at 2:54pm
Hello.
 
While cranking up the security of our small discussion board, I moved the database outside the htdocs directory and into the private directory and reset the two common.asp files to the physical address:
 
e:\domains\e\domainname\user\private\newname\newname.mdb
 
and the site works fine. But when I try to compact and back up the database I get an error message
 

Microsoft VBScript runtime error '800a0034'

Bad file name or number

    /forum/admin/compact_access_db.asp, line 121

Line 121 reads:

objFSO.CopyFile strDbPathAndName, Replace(strDbPathAndName, ".mdb", "-backup.mdb", 1, -1, 1)

Do I need to edit something in here?

Thanks for any and all help.




Replies:
Posted By: huwnet
Date Posted: 31 December 2005 at 4:16pm
Sometimes I have had problems with the files just being corrupt.

You might be able to fix it just by re-downloading WWF and then overwriting compact_access_db.asp with the new one Big smile

Also you will get a better response in the support forum as it is an error with WWF not your mistake Wink



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