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

  New Posts New Posts RSS Feed - Compacting Access?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Compacting Access?

 Post Reply Post Reply
Author
Hobanart View Drop Down
Groupie
Groupie
Avatar

Joined: 02 August 2004
Location: United States
Status: Offline
Points: 40
Post Options Post Options   Thanks (0) Thanks(0)   Quote Hobanart Quote  Post ReplyReply Direct Link To This Post Topic: Compacting Access?
    Posted: 18 January 2005 at 8:07pm
My Access based forum seems to have slowed, even though I periodically barch delete older topics. I tried using the compact and repair function in Access, but for some reason it makes the file like four times as big. What's going on here?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 January 2005 at 5:23am
It shouldn't do although it will make a back-up copy of the original.

Try downloading the database and open it in Access and select the 'Compact and Repair Tool' from the Tools menu, then re-upload the database.
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.