On Thu, 3 Dec 2009 11:02:01 -0800, Make table query <Make table
I am using a make table query to archieve data in a table. I would like to
append the date / time behind the table name during the process. What is the
best method for accomplishing this.
Sorry, but that's a very bad idea.
An archive should be stored external to the current database file. The
greatest risk to your data is corruption of the .mdb file - not of the
individual table. Having all your archive tables in the same database is
putting all your eggs in one basket, and making the basket more fragile in the
process!
Why do you feel that you need to archive data? Are you having (demonstrated,
real) performance problems which cannot be solved by proper indexing? How big
is your table - tens of millions of records, or smaller? Could you not get the
desired result by just adding a Yes/No field named Archived to the table, and
basing your forms/reports on a query selecting unarchived (or archived)
records?
