请问在这一段代码怎样使它可以访问带密码的数据库,比如我的数据库wolter的密码为123,求各位xdjm帮帮小弟.....谢谢!
Dim cnn As New ADODB.Connection
With cnn
.Mode = adModeReadWrite
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = App.Path & "\wolter.mdb"
.Open
End With
另外一个小问题...我装的access 2003,是不是不能对access 97文件进行修改,那要怎么样才能修改access 97数据库文件.
Dim cnn As New ADODB.Connection
With cnn
.Mode = adModeReadWrite
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = App.Path & "\wolter.mdb"
.Open
End With
另外一个小问题...我装的access 2003,是不是不能对access 97文件进行修改,那要怎么样才能修改access 97数据库文件.
& "Jet OLEDB:Database Password=1234;User ID=;Data Source=" & App.Path & "\wolter.mdb;"cnn.Open
With cnn
.Mode = adModeReadWrite
.CursorLocation = adUseClient
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = App.Path & "\wolter.mdb;Jet OLEDB:Database Password='123'"
.Open
End With