How do I archieve database file to decrease the size of the file

Access data base. I need to purge some old data to make the file smaller. I
delete file entries in the tables but that does not decrease the size of the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13626-how-do-i-archieve-database-file.html
file.

Help

Thank You

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

On Thu, 20 Jul 2006 09:31:02 -0700, FrankRussell wrote:

> Access data base. I need to purge some old data to make the file smaller. I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13626
> delete file entries in the tables but that does not decrease the size of the
> file.
>
> Help
>
> Thank You

Access does not restore deleted file space until after you also
compact the database.
Click on Tools + Database Utilities + Compact and Repair database
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13626
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

FrankRussell wrote:

>Access data base. I need to purge some old data to make the file smaller. I
>delete file entries in the tables but that does not decrease the size of the
>file.

I realize you've already deleted the data but why even bother? Leave
it around for comparison or reporting purposes.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm