My database keeps crashing because there is so many old files in my database.
How do I archieve these old files in order to lessen the chance of the
database crashing?
Also, after I archieve how do I retrieve them?

Databases don't crash because of old files. In fact, what do you mean by "old
files"? Are you talking about old records or are you importing documents into
Access such as image files?

Describe the crash. What happens?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"T.Harp" wrote:

> My database keeps crashing because there is so many old files in my database.
> How do I archieve these old files in order to lessen the chance of the
> database crashing?
> Also, after I archieve how do I retrieve them?

On Thu, 8 Nov 2007 05:08:01 -0800, T.Harp <(E-Mail Removed)>
wrote:

>My database keeps crashing because there is so many old files in my database.
> How do I archieve these old files in order to lessen the chance of the
>database crashing?
>Also, after I archieve how do I retrieve them?

How big is the .mdb file? Have you used Tools... Database Utilities... Compact
and Repair?

Bear in mind that Access databases do not contain "files" - what do you mean
by the term?

John W. Vinson [MVP]