On 08/02/2009 in message Allen
Browne wrote:

Try it. My guess is that it will make no difference. 12k records is tiny
for Access.

OK, I will try it and see, it would certainly make things easier.

If you really want to move expired records out to a different table,
here's how it's done:
Archive: Move records to another table - copy + delete in a transaction
at:
http://allenbrowne.com/ser-37.html

I have to say I find your website enormously useful, thank you :-)

I tend to use C#, is there an equivalent of DBEngine(0) in C#? I can
generally manage to convert VB/C# but that one always throws me!

--
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)