>Great, thanks
>
>One other question, when I do:
>
>oConnection = CREATEOBJECT("ADODB.Connection")
>?oConnection.Version
>>
>I get 2.6 returned.
>
>How do I know this will work on all my user's Pc's? I have
>some users on NT4, some on 2000 and some on 98.
It depends on the version of MDAC that is installed. Off the top of my head, MDAC 2.5 ships with Windows 2000, MDAC 2.1 ships with Windows 98, and some service pack (SP5?) for Windows NT ships MDAC 2.5. If MDAC (which includes ADO) isn't on the machine, your CREATEOBJECT will fail, so wrap it in an error handler.
Mike Stewart