Database connectivity

[vks.gautam1]

VB.NET

As im trying to connect msaccess database which have a password

This my oledbconnection

DIM cn as oledbconnection

cn=new oledbconnection("provider=microsoft.jet.oledb.4.0;data source=Path of file ;User Id=Admin;Password=Password of your database;")


when im trying to search it is giving error of "cannot find installable isam"



this is my full code


Dim cn As OleDbConnection
Dim ad As OleDbDataAdapter
Dim ds As DataSet
Dim q As String

Try
q = "select * from mef_detail where pack_no='" & TxtPktNo.Text & "'"
cn = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=D:\CHESNUT_MASTER\HUB\chesnut_master.mdb;user id=Admin;Passwrod=Godfather;")
cn.Open()
ds = New DataSet
ad = New OleDbDataAdapter(q, cn)
ad.Fill(ds, "mef_detail")
DataGridView1.DataSource = ds.Tables(0)

Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
End Class

 

[vks.gautam1]

This was the mistake earlier. "Passwrod=" & User Id

But now after these corrections. it is giving another problem.

"cannot start your application. The WorkGroup Information file is missing or opened exclusively by another user".