Web Wiz Forums - Compact Database

Print Page | Close Window

Compact Database

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=17692
Printed Date: 13 April 2026 at 9:30pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Compact Database

Posted By: AlanP
Subject: Compact Database
Date Posted: 31 December 2005 at 4:45pm

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: WebWiz-Bruce
Date Posted: 03 January 2006 at 1:54pm

Maybe worth doing this the long way (and the way I prefer)

Download the database
Open in Access
Compact and repair the database from the Tools menu
Re-upload the database

-------------
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