I need to start our order database over for the new year. I do not know how
to do this while keeping the same format and saving the old information for
occasional use. I thought deleting everything and then using Save As may
work but Access updates every couple of seconds...Is it possible???
Unless your database is *really* huge (as in over 1,500,000,000 bytes)
it may not be either necessary nor beneficial to do so. Instead, just
keep using the database as it is; rather than using your tables
directly, use Queries selecting records for the current year (or a
previous year).
An Access database IS NOT A DOCUMENT. "Save As" is not really
relevant. If you really do want to do this, use Windows Explorer to
make a copy of your database; keep the old database in a safe place,
and open the new one. Carefully and judiciously run Delete queries to
delete existing data from the tables (say, if you have a lookup table
of cities and postal codes, DON'T delete anything from it; you'll
surely need that information). When you're done deleting use Tools...
Database Utilities... Compact and Repair Database to recover the
freed-up space (Access won't do so on its own).
John W. Vinson[MVP]
