给了例题你看 Dim cn As New ADODB.Connection Dim sql As String Dim zf As String Dim ip As String Dim a As String a = Text2.Text zf = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" & a & "\局域网数据交换\db1.mdb;User Id=admin;Password=" '\\服务器名或IP\共享目录名\数据库名.mdb 'zf = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.4\局域网数据交换\db1.mdb" sql = "insert into xm(xm)values('" & Text1.Text & "')" cn.Open zf cn.Execute (sql) cn.Close Set cn = Nothing
Dim cn As New ADODB.Connection
Dim sql As String
Dim zf As String
Dim ip As String
Dim a As String
a = Text2.Text
zf = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\" & a & "\局域网数据交换\db1.mdb;User Id=admin;Password="
'\\服务器名或IP\共享目录名\数据库名.mdb
'zf = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.4\局域网数据交换\db1.mdb" sql = "insert into xm(xm)values('" & Text1.Text & "')"
cn.Open zf
cn.Execute (sql)
cn.Close
Set cn = Nothing
AdoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;User Id=BMS;Password=bms;Data Source=\\IP地址\共享目录名ta\数据库名"
报错说:工作组文件信息丢失,或是已被其他用户以独占方式打开这是咋回事啊!
这样就可以了你试试