Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Compact and Repair Fails
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Compact and Repair Fails

 Post Reply Post Reply
Author
tcampione View Drop Down
Newbie
Newbie
Avatar

Joined: 25 April 2004
Location: United States
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote tcampione Quote  Post ReplyReply Direct Link To This Post Topic: Compact and Repair Fails
    Posted: 01 May 2005 at 5:40pm
Actually, the admin function succeeds to the point that the original (old) db is deleted.  That is, the backup is created, the -tmp is created, and the -tmp is compacted.
 
The next step is delete the old db. But, the delete function fails with a 'permission denied' message.
 
Any help in troubleshooting, or otherwise clearing the problem is appreciated.
 
/*tom*/
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 01 May 2005 at 9:35pm
If you've already checked with your isp to ensure that the directory has acd permissions, you might want to stop/lock the db in the admin section before doing a commpact and repair. Wait a minute or two afer locking it for any user activity to clear.
 
Also, check that the .lck file is delete-able.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
tcampione View Drop Down
Newbie
Newbie
Avatar

Joined: 25 April 2004
Location: United States
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote tcampione Quote  Post ReplyReply Direct Link To This Post Posted: 02 May 2005 at 8:16am
Thanks.... I'll give these a try. 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.