Classic ASP Discussion - Compact and Repair

Print Page | Close Window

Compact and Repair

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14044
Printed Date: 30 March 2026 at 2:45pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Compact and Repair

Posted By: rob_andy
Subject: Compact and Repair
Date Posted: 28 February 2005 at 4:52pm

Hi there,

I have been trying to implement a compact and repair script for a db I need to reset autonumbers on. I have seen previous threads and tried the free samples, I have even tried to doctor the webwiz version for the forum but I get permission errors. I have setup the pages and db with full permission on the webserver but this has no effect. Any suggestions.

Replies:

Posted By: Phat
Date Posted: 28 February 2005 at 9:00pm

compact and repair will not reset the autonumber fields.

To do this you need to delete the field and then re create it.