Compact Database Error
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=8661
Printed Date: 07 April 2026 at 9:39am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Compact Database Error
Posted By: JimGo
Subject: Compact Database Error
Date Posted: 08 January 2004 at 12:36am
|
Hello- I get the following error while trying to compact the access database.
Server object error 'ASP 0177 : 8002801d' Server.CreateObject Failed /admin/compact_access_db.asp, line 118 Library not registered.
Thanks -Jim |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 08 January 2004 at 6:27am
|
This means that the server you are using is not running the latest MDAC drivers. If you run the server yourself download them from:- www.microsoft.com/data If you don't run the server yourself, get onto the server admin and tell them it's about time they got their arse in gear and updated the server with the latest drivers and patches. ------------- 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 |
Posted By: JimGo
Date Posted: 08 January 2004 at 12:06pm
|
Thanks - Actually I needed to register the Jet Engine dll to get rid of that error. Now I get this one. Microsoft JET Database Engine error '80040e17' Database already exists. /admin/compact_access_db.asp, line 124 The only file is the /admin/database dir is the db and a a wwforu m-tmp and the backup that the compact procedure creates ??? |
Posted By: WebWiz-Bruce
Date Posted: 09 January 2004 at 6:13am
|
You need to delete the file ending in -tmp
------------- 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 |
Posted By: JimGo
Date Posted: 09 January 2004 at 1:27pm
|
BoRg- I did and get the same error. Thanks |
Posted By: WebWiz-Bruce
Date Posted: 09 January 2004 at 1:57pm
|
Looks like for some reason then this fetaure doesn't work on the server you are on. If you wish to compact and repair the database you will have to do it by hand and download and open the database in access and choose compact and repair database from the tools menu. ------------- 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 |
Posted By: JimGo
Date Posted: 09 January 2004 at 2:18pm
| I probably need Access on that Server? |
Posted By: thekiwi
Date Posted: 09 January 2004 at 2:24pm
|
No ... you need access on the machine you download your access database to. Alternatively, use this package: http://www.stpworks.com/DesktopDefault.aspx?tabindex=1&tabid=3&articleid=3&linkid=2 - http://www.stpworks.com/DesktopDefault.aspx?tabindex=1&t abid=3&articleid=3&linkid=2 It allows you to maintain an access database via a WWW browser. It truly is excellant ... and it has a menu option for compacting and backing up. ------------- Cheers TheKiwi http://www.infobahn.co.nz - Internet Infobahn - website design and hosting |
JimGo wrote:Posted By: JimGo
Date Posted: 09 January 2004 at 2:37pm
|
thekiwi Worked like a charm. Thank you VM |