I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership.
Now I was trying to connect Msaccess from PC1 using below code.
cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security Info=False"
and i was able to connect. However i have broswed that remote folder already on PC1 that time.
But i want to pass PC2 window's User/pass as well in code itself. so that i don't need to open shared folder seaparatly.
I found this one Click Here .. Mikey can help with exact code.