MS Access DB access problem in C#

Advertisement
Hello everybody,I m in new in C#. I gave password to my MS Access DB.Ms Access only requires password to set,it doesn't require user name.So I did it as they require.Now I made a very simple c# program which access the DB and retrieve some info.When I did it without giving the DB password,everything works well.But as I entered password in my DB,nothing works.This is supposed to be.Now,when I tried to add a new connection frm server explorer,firstly I set the name of the db provider,then next in the connection tab there are three fields-DB NAme,user name and password.Now that I know the DB name and the password I gave in my MS Access DB.But what to give in the user field?I didnt set any user name in my MS Access DB bcos it didnt require.If I set user name-"Admin", an error says-"cant open....work group information file is missing or opened exclusively by another user". I closed all(every other program) Access Db during adding new connection.Would anybody tell me how to solve it. I think I shud set the password different way in access.

Public cn As ADODB.Connection
Public Function DBConnect() As Boolean

On Error GoTo OpenErr

Dim MSDatabase
Dim str As String

Set cn = New ADODB.Connection

cn.CursorLocation = adUseClient
str = "DBQ=" & App.Path & "\db.mdb;" + "DefaultDir=" & App.Path & ";" ' database name and directory
str = str + "Driver={Microsoft Access Driver (*.mdb, *.accdb)};"
str = str + "PWD=dbb;UID=admin;" ' password & user id
str = str + "DriverId%;FIL=MS Access;MaxBufferSize
48;MaxScanRows=8;PageTimeout=5;SafeTransactions=0; T hreads=3;UserCommitSync=Yes;"

cn.ConnectionString = str
cn.Open
DBConnect = True
Exit Function

OpenErr:

MsgBox "Error Opening " & MSDatabase & vbNewLine & Err.Description, vbCritical, "Open Database Error"
DBConnect = False

End Function