Public Const conn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist security Info=False;Data Source=app.path+'\服装厂管理.mdb'"
写错了
应该为:
public const conn="provider =Microsoft.jet.oledb.4.0;Persist security Info=False;Data source=" & app.path" & "\服装厂管理.mdb"
写错了
应该为:
public const conn="provider =Microsoft.jet.oledb.4.0;Persist security Info=False;Data source=" & app.path" & "\服装厂管理.mdb"
Public rs As ADODB.Recordset
Public Const conn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist security Info=False;Data Source=" & app.path & "服装厂管理.mdb"
可以这样写:
Public Const conn = "Provider=Microsoft.Jet.OLEDB.4.0;Persist security Info=False;" & "Data Source=" & app.path & "\服装厂管理.mdb"
"Provider=Microsoft.Jet.OLEDB.4.0;Persist security Info=False;Data Source="+app.path+"+'\服装厂管理.mdb'"
可以吗?
请试以下!
private db As ADODB.Connection
private rs As ADODB.Recordset
private cnn as string
const cnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;" & app.path &\服装厂管理.mdb'"
然后用con向变量赋值就可以了,被赋值语句即为连接数据库字符串
给分吧
标准模块里写下了如下语句:
private db As ADODB.Connection
private rs As ADODB.Recordset
private cnn as string
const cnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;" & app.path & "\服装厂管理.mdb"
然后用cnn向db赋值就可以了,被赋值语句即为连接数据库字符串
给分吧!谢了!