none
Connection string for Encrypted MS Access 2007 database RRS feed

  • Question

  • Hi all,

    I have an encrypted (MS Access 2007 Enterprise) database, can any one guide me regarding the connection string

    by using C#.Net 2005.

     

     

    Thanks

     

    Noor ul Amin

    Tuesday, September 11, 2007 7:45 AM

All replies

  • The following MS Access connection strings might help you

     

    MS Access ODBC connection strings

    Standard Security:
        "Driver={Microsoft Access Driver (*.mdb)};" & _
        "DBQ=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "Uid=Your_Username;Pwd=Your_Password;"

    Workgroup:
    "Driver={Microsoft Access Driver (*.mdb)};" & _
        "Dbq=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "SystemDB=E:\ftp_data\shared\users\account_1\database\dbname.mdw;"

    Exclusive
    "Driver={Microsoft Access Driver (*.mdb)};" & _
        "DBQ=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "Exclusive=1; Uid=Your_Username; Pwd=Your_Password;"

    MS Access OLE DB & OleDbConnection (.NET framework) connection strings

    Open connection to Access database:
    "Provider=Microsoft.Jet.OLEDB.4.0; " & _
        "Data Source=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "User Id=admin; Password="

    Open connection to Access database using Workgroup (System database):
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "Jet OLEDBTongue Tiedystem Database=E:\ftp_data\shared\users\account_1\database\dbname.mdw"

    Open connection to password protected Access database:
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Data Source=E:\ftp_data\shared\users\account_1\database\dbname.mdb;" & _
        "Jet OLEDBBig Smileatabase Password=Your_Password"

    Cheers
    Tuesday, September 11, 2007 9:09 AM
  • There are no special connection string arguments for an encrypted Access database. Simply encrypting it does not prevent anyone from opening the Access database and looking at the contents. You must also use either a database password or implement user-level security.

     

     

     

    Wednesday, September 12, 2007 12:41 PM
  • Thank you very much for you reply, actually I have found that attribute it is some thing like " Jet OLEDB: Dabase Password = pwd". Regarding database encryption is concerned, I have encrypted it with a passwod using the MS Access 2007 Enterprise, Encryption feature. Is it not safe now?

     

     

     

    Wednesday, September 12, 2007 2:37 PM
  • Encrypting the database prevents someone from using a file editor to look at the database contents, however, Access database passwords aren't particularly secure since there are utilities available that can recover these passwords.

     

    So it may be safe from the prying eyes of the average person but not from someone who really wants to find out what is in it.

     

    Wednesday, September 12, 2007 4:59 PM
  • Then, can you please tell me which database will be perfect one in a scenario where the client suggests that all the tables should contain encrypted data whos aim is to save it from prying eyes.

     

    Thanks for you reply.

    Thursday, September 13, 2007 9:58 AM
  • I don't know what other database requirements you have but you may want to try SQL Server Express or SQL Server Compact Edition.

     

    Thursday, September 13, 2007 11:51 AM