Thanks for the reply.

Tested it, the connection string is fine.
Tested the sql statement also, it's fine.

It works fine when I create my own connection, command and recordset objects.
(dim cntTest as adodb.connection ... etc.)

Actually, that's what I've had to do considering I couldn't get the Adodc object to work.

I just would have preferred using the adodc object. Plus, it should work. I just don't get it.