Re: Cleaning up database



Why? Are you close to the size limits (1 Gb for Access 97 and earlier, 2 Gb
for Access 2000 and newer)?

If you're not near the size lmits, there's no reason to remove the data.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Cameron" <Cameron@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4544D053-F167-4624-B277-15D516A7E8A8@xxxxxxxxxxxxxxxx
I have about 10 years worth of data in a database, and i would like to only
have 2 years. Is there a way to strip out the other 8 years of data and
put
it in a seperate database?


.



Relevant Pages