本地access數(shù)據(jù)庫(kù)無(wú)密碼的可以連上,有密碼的怎么練?

熱心網(wǎng)友

Here is a typical example of ADODB connection string. Assume the password of access database is "password", and the database file is "C:\test.mdb".dim conn as ADODB.Connectionset conn=new adodb.connectionconn.open _ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist _ Security Info=False;Jet Password=password"

熱心網(wǎng)友

"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=123;"