Thanks
>One further point: MSDASQL is for any ODBC driver, not just Access. I just read my message again and it might give the wrong impression.
>
>>Thanks for clarification.
>>
>>>Hi Yuri,
>>>
>>>That would use the OLEDB provider for ODBC drivers, which at the end uses the Access ODBC driver instead. When you create the UDL file this is the default, you need to select the native OLEDB provider for the data source you want if one exists. Which it does in the case of Access.
>>>
>>>Cheers,
>>>Crescencio
>>>
>>>>Try:
>>>>oconnection = Createobject("adodb.connection")
>>>>with oConnection
>>>>.Provider="MSDASQL.1"
>>>>....
>>>>
>>>>The exact connection string you could get when creating a New Microsoft Data Link.UDL file.
>>>>
>>>>>Thanks for the response.
>>>>>I am doing it in ADO.