Hi,

It was so simple to check the connection string using UDL. Thanks for pointing it out. It works now with following connection string:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath & "User ID=ABC; Mode=Share Deny None;Jet OLEDB:System database=\\MySERVER\MyWeb\oamsweb.mdw"

Thanks to Jason & Guy as well for their suggestions.

Regards

>You don't need VS to create a UDL file. You do need MDAC 2.x installed, which I assume you have since you are using ADO. You can create an empty text file, change the extension to UDL and then double-click it. You should go into a wizard that lets you choose all the connection parameters visually. Once you have tested the connection exit the wizard and open the UDL file with notepad. The connection string should be in the first few lines of it.
>
>Hope this helps.
>