Web Wiz Support and Community Forums : Compact Database https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 21:35:52 +0000 Tue, 03 Jan 2006 13:54:25 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17692 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Compact Database : Maybe worth doing this the long...]]> https://forums.webwiz.net/compact-database_topic17692_post96323.html#96323 Author: WebWiz-Bruce
Subject: 17692
Posted: 03 January 2006 at 1:54pm

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

  1. Download the database
  2. Open in Access
  3. Compact and repair the database from the Tools menu
  4. Re-upload the database
]]> Tue, 03 Jan 2006 13:54:25 +0000 https://forums.webwiz.net/compact-database_topic17692_post96323.html#96323 <![CDATA[Compact Database : Hello. While cranking up the...]]> https://forums.webwiz.net/compact-database_topic17692_post96202.html#96202 Author: AlanP
Subject: 17692
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.

]]> Sat, 31 Dec 2005 16:45:01 +0000 https://forums.webwiz.net/compact-database_topic17692_post96202.html#96202