How to reduce the size of the MS Access

This is a discussion on "How to reduce the size of the MS Access" within the Databases section. This forum, and the thread "How to reduce the size of the MS Access are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Oct 4th, 2005, 22:33
Junior Member
Join Date: Sep 2005
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
How to reduce the size of the MS Access

Hi:

I have one problem.

If I create many many tables, then delete them, then create new tables, so on. The size of the MS Access file will become large.

So, how can I reduce the size of the file? Even though I delete the tables, the size will NOT become less, so how to reduce the size of the file?

Please let me know, thanks a lot. Thanks.
Reply With Quote

  #2 (permalink)  
Old Oct 5th, 2005, 15:34
Rob's Avatar
Rob Rob is offline
Head Admin & CEO

SuperMember
Join Date: Jul 2003
Location: at my desk
Age: 34
Posts: 2,952
Blog Entries: 7
Thanks: 7
Thanked 4 Times in 4 Posts
Send a message via MSN to Rob Send a message via Skype™ to Rob
It's actually quiet easy...

Open up msaccess (just msaccess... dont open a db)

On the tools menu you will find a compact/repair database option.

It will ask you to choose the DB you want to compact.

Good luck
__________________
Rob - SEO Specialist
Owner & Founder of Webforumz.com

I am currently unavailable for private work
Reply With Quote
Reply

Tags
reduce, size, access

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments reduce speed? alexgeek PHP Forum 5 Jan 21st, 2008 10:53
Best way to reduce file size of .jpg lmc148 Graphics and 3D 12 Jan 17th, 2008 07:43
ASP Multi users Access to Microsoft Access ish Classic ASP 0 Apr 26th, 2007 20:05
Getting the Size Right ! Accurax Web Page Design 5 Jan 10th, 2007 07:34
maximum size for jpg in web kati Graphics and 3D 9 Jun 16th, 2006 21:17


All times are GMT. The time now is 06:33.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43