OLEDB Connection
-
I have a mdb database.It has a password (123456), i found out password with a password cracker program. I exactly dont know why this password exist . I try to connect this database via VB.Net, OLEDB Connection. My Connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;Password=123456;Data Source=C:\Documents and Settings\creek\Desktop\AC115DataBase.mdb; Mode=Read;Persist Security Info=True"i cant connect to database with this connection string. I get this error "Application cannot be started. Work File is missed, or any user opened file excluesive mode" i dont know user name or any extra information about mdb file. I am so confused. Question is What is wrong, -
I have a mdb database.It has a password (123456), i found out password with a password cracker program. I exactly dont know why this password exist . I try to connect this database via VB.Net, OLEDB Connection. My Connection string is
"Provider=Microsoft.Jet.OLEDB.4.0;Password=123456;Data Source=C:\Documents and Settings\creek\Desktop\AC115DataBase.mdb; Mode=Read;Persist Security Info=True"i cant connect to database with this connection string. I get this error "Application cannot be started. Work File is missed, or any user opened file excluesive mode" i dont know user name or any extra information about mdb file. I am so confused. Question is What is wrong, -
Where did you get the database?
Work hard and a bit of luck is the key to success.
You don`t need to be genius, to be rich.
at the end i solved my problem myself :D Line i missed is Bold.
Dim oOleDbConnection As New OleDb.OleDbConnection Dim strPassword As String = "123456" Dim strDataBasePath As String = "C:\Documents and Settings\creek\Desktop\AC115DataBase.mdb" Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strDataBasePath & ";" & _ "**Jet OLEDB:Database Password=" & strPassword & ";**"