access 網路共用,連線字串

1.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\xxx.xxx.xxx.xxx\db$\test.mdb;Persist Security Info=False

2.
cnn.open "Provider=Microsoft.Jet.OLEDB.4.0;data source=\\192.168.0.1\someshare\mydatabase.mdb;"

3.
DAO
Set db = DAO.OpenDatabase("\\192.168.0.1\SHARENAME\Database.MDB", False, False, ";pwd=LetMeIn")

ADO
cnn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.1\SHARENAME\Database.MDB;Jet OLEDB:Database Password= LetMeIn"