dbEngine is provided by the DAO library.
You can also execute query statements with the ADO library if you prefer.

If you need to use C/C++ on the A2007 for some reason, this might help:
http://msdn.microsoft.com/en-us/library/cc811599.aspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jeff Gaines" wrote in message
...
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)