Database Filesize

healso2000 · 13-08-2006, 03:08 PM

Hi.

I have recently split one MS Access database into two by copying it and then stripping out the tables that I don't want in each respective database. The problem is that I now have two databases that are each as large as the first one.

Is there a was of reclaiming this filesize?

I've heard talk of the 'Vacuum' command. Would this work in Access and if so how should I employ it?

paulredpath · 13-08-2006, 06:49 PM

Im pretty sure there is a compact command, and you can download programs that will do this for you as well.

healso2000 · 13-08-2006, 10:30 PM

Sorted That... Thanks For Your Help!

13-08-2006, 03:08 PM	#1 (permalink)
healso2000 Registered User Join Date: Mar 2005 Location: Isle of Man Posts: 8	Database Filesize Hi. I have recently split one MS Access database into two by copying it and then stripping out the tables that I don't want in each respective database. The problem is that I now have two databases that are each as large as the first one. Is there a was of reclaiming this filesize? I've heard talk of the 'Vacuum' command. Would this work in Access and if so how should I employ it?

13-08-2006, 06:49 PM	#2 (permalink)
paulredpath Bring me your problems :p Join Date: Jan 2003 Location: /dev/ahhhhhhhhh Posts: 3,536	Im pretty sure there is a compact command, and you can download programs that will do this for you as well. __________________ Paul Redpath paul@catalyst2.com Go on, review Us at OC Host Review!

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

13-08-2006, 10:30 PM	#3 (permalink)
healso2000 Registered User Join Date: Mar 2005 Location: Isle of Man Posts: 8	Sorted That... Thanks For Your Help!