Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Persist Security Info = False; Data Source =" & app.path & "\guanli.mdb;Jet OLEDB:Database Password= 167"
cnn.Open ConnectionString以上可以连接到数据库
=============================
mfuwuqi = app.path Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Persist Security Info = False; Data Source =" & Trim(mfuwuqi) & "\guanli.mdb;Jet OLEDB:Database Password= 167"
cnn.Open ConnectionString
以上可以连接到数据库==========================================
mfuwuqi = GetSetting("fuwuqi", "fuwu", "qi")其实, GetSetting("fuwuqi", "fuwu", "qi")的结果也是mfuwuqi = app.path
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Persist Security Info = False; Data Source =" & Trim(mfuwuqi) & "\guanli.mdb;Jet OLEDB:Database Password= 167"
cnn.Open ConnectionString运行结果出现错误
“E:\soft\sunsoft\app.path\guanli.mdb不是一个有效的路径。确定路径名称是否拼写正确,以及是否连接到文件所在的数据库========================================
---------------------------------------------------------------
mfuwuqi = app.path
mfuwuqi = "app.path"
这两个是不一样的