I have written an app for my daughter in C# with an Access 12 database
holding the data. It creates html pages for a website based on details
provided by customers. She is adding around 200-300 records a month, so
2,500 to 4,000 records a year. When the period for showing the record on
the website expires (60 days) the records are flagged.

I need to consider the best way of archiving records once they no longer
need to be shown on the website. I could just leave them in the main table
and use the flag for selection or I could move them out to an archive
table, or even to separate archive tables for each financial year.

The easiest way is to leave them in the main table and use the flag for
selection but I am not sure what performance hit this might cause. Is it
much slower to search a table of, say 12,000 records against a table
of,say, 1,000 (representing the current live records)?

Any suggestions for 'best practice' would be appreciated :-)

--
Jeff Gaines Damerham Hampshire UK
That's an amazing invention but who would ever want to use one of them?
(President Hayes speaking to Alexander Graham Bell on the invention of the
telephone)