In ACCESS databases without a password, I can be normal link to ACCESS the database, but once the password is not line, I use the statement is:
Dim Conn As New OleDb. OleDbConnection (" Provider=Microsoft. ACE. The OleDb. 12.0; The Data Source=D: \ System \ System. Accdb; The Jet OLEDB: DataBase Password='" & amp; DBPassword & amp; "'")
An error statement is:
Cannot open database 'application may not be able to identify the database, or the file may be damaged,
In addition, I have modified the ACCESS database encryption method, both the old and the new cannot link,,
CodePudding user response:
I also encountered this problem, a day or two up or not, built ACCESS2010 database not at first sight, can use access2003,The access2003 connection string for
"The Provider=Microsoft. Jet. The OLEDB. 4.0. Data Source=| DataDirectory | \ Data. The MDB. Persist Security Info=True; Jet OLEDB: Database Password=* * * * * * * * "
That I know ACCESS2010 VS2012 connection, please show the Microsoft. ACE. The OLEDB. 12.0 this had already installed,
CodePudding user response:
Try the password=string without single quotation marks? I also am access2010 editing, but down into the MDB format,CodePudding user response:
Try to use double quotation marks:"The Provider=Microsoft. ACE. The OLEDB. 12.0. The Data Source=D: \ System \ System. Accdb; The Jet OLEDB: DataBase Password="" "" & amp; DBPassword & amp; "" ""
CodePudding user response:
Generally, it should be not use quotation marks,