1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MS Access DB access problem in C#

Discussion in 'C#' started by imported_tanvirtonu, Oct 23, 2007.

  1. imported_tanvirtonu

    imported_tanvirtonu New Member

    Oct 23, 2007
    Likes Received:
    Trophy Points:
    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.
  2. praspam

    praspam New Member

    Feb 22, 2012
    Likes Received:
    Trophy Points:
    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
    DBConnect = True
    Exit Function


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

    End Function

Share This Page