I was provided some code to modify and I would like to modify the data source below from using a mapped P: drive to using the UNC mapping since various individuals may not have the same mappings. I tried the syntax: "Data Source=//<servernamehere>/.... without success. Any help appreciated.
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=P:\OCO Office\Database\Contract\Form98\testform98.mdb;"
DESIRED PATH -- file://hfsor121-0372/public/Sec/ConOvrst/OCO%20Office/Database/Contract/Form98/CSform98.mdb