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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

Help

Thank You
 
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.

Help

Thank You
Click to expand...

Access does not restore deleted file space until after you also
compact the database.
Click on Tools + Database Utilities + Compact and Repair database
 
FrankRussell said:
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.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to decrease size of database 1
How do I Archieve old files in my database? 2
How Free Up Size when Delete Tables? 5
Purging Data 1
How to reduce the file size of Access 2
Browse button for access form 1
Field Size Decreases 2
How to Convert EML to PST files? 1

Back
Top