You could create* a similar database for archiving, link** the tables in
that database, use an Append query to copy the no-longer-needed records to
the archive, then use a Delete query to remove them from the primary
database, after which you Compact*** the primary database.
* create an empty database, and on its File menu, Get External Data, Import,
and choose "Structure Only"
** in the main database, on the File menu, Get External Data, Link
*** in the main database, on the Tools menu, Database Utilities, Compact and
Repair Database
Larry Linson
Microsoft Access MVP
"Dean" <de**********@hotmail.com> wrote in message
news:45**************************@posting.google.c om...
I have a Microsoft Access database that is getting to large. I want
to be able to backup old records and remove them from the database.
What is best way to do this?