Today, I suddenly remembered a problem with Password data in encrypted Access data, I thought, if my code (ASP) was down by Down, wouldn't you use this password to enter my database? I have seen the article before, but I forgot it now (immediately check the information, know that it is not, the next analysis)
Transfer to the topic: Create a connection OLEDB in the VS2003.NET Server Explorer, the database is encrypted, and it is not possible! It prompts: It has been opened exclusive by other programs! (Nothing can be opened) I just opened a VS. NET is already (new project), the restart is also the case, why? The password is correct (if it is not encrypted). It's not good, I will write Code directly, but unfortunately, I still fail, the problem is still this! Microsoft is bullying my rookie, I am unbiating, then I tried it to connect (directly writing code), but I can (excite)! ! But why don't you use oleDB? I hope that the master can have a few tricks, the younger brother is here!
Below is the code using an ODBC connection database: imports system.dataimports system.data.odbc'imports system.data.oledb public connString = "driver = {Microsoft Access Driver (* .mdb)}; pwd = 123456; dbq = xxxx. MDB "'" provider = microsoft.jet.Oledb.4.0; database password = 123456; Data Source = _ " Application.startupPath " /xxx.mdb "This is the use of OLEDB connection, can't connect! Public Conn As New OdbcConnection (Conntring) 'Connecting Access Database
