本地Access数据库可以通过下面的语句来连接访问:
Dim conn As New ADODB.Connection '声明连接对象
Dim connectionString As String '连接字符串
connectionString = "uid=admin;pwd=Moritetsu;DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" & App.Path & "\数据库.mdb"
conn.Open connectionString若要用类似上面的语句连接访问远程Access数据库,请问要怎么写?谢谢
Dim conn As New ADODB.Connection '声明连接对象
Dim connectionString As String '连接字符串
connectionString = "uid=admin;pwd=Moritetsu;DRIVER={Microsoft Access Driver(*.mdb)};DBQ=" & App.Path & "\数据库.mdb"
conn.Open connectionString若要用类似上面的语句连接访问远程Access数据库,请问要怎么写?谢谢
dim conn as new adodb.connection
With conn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\\计算机名或IP地址\共享目录名\数据库名.mdb"
.Open
.CommandTimeout = 300
End With