Web Wiz Forums - access mdb compact and repair problem

Print Page | Close Window

access mdb compact and repair problem

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=12579
Printed Date: 11 April 2026 at 1:50pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: access mdb compact and repair problem

Posted By: astral
Subject: access mdb compact and repair problem
Date Posted: 17 November 2004 at 3:58am

i tried to use the compact and repair function in the admin page but it showed me this error...

Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument

/admin/compact_access_db.asp, line 110

may i know what happen and how to solve it??

thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 November 2004 at 4:44am

It could be a corrupted file, try re uploading files again.

It could also be that the server doesn't support this method as the ADO drivers have not been updated to a version that does support compacting and repairing.

If you have access to the server you need to install the latest MDAC drivers from www.microsoft.com/data

It could also be a problem with your database, you can compact and repair an access database from inside MS Access. Download your database, open in MS Access, and select 'Compact and Repair' 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: dpyers
Date Posted: 17 November 2004 at 11:21am

To check your ado version, use the following code

<%
dim objAdoVer
Set objAdoVer = Server.CreateObject("adodb.connection")
response.write "ADOVersion = " & objAdoVer.Version
Set objAdoVer = Nothing
%>

I believe the latest version is 2.7 or 2.8

-------------

Lead me not into temptation... I know the short cut, follow me.