Opening accdb with password

Discussion in 'Databases' started by davherb, Mar 28, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. davherb

    davherb

    I am able to open an Access 2007 database without the password but not with a password.

    e.g.
    strCon = ("Provider= Microsoft.ACE.OLEDB.12.0;Jet OLEDB:Database Password=thePW;Data Source=" & Server.MapPath("\_database\CALENDAR.accdb"))

    Checked KB but did not find an example for encrpted with password Access 2007 database.

    Dave
     
    davherb, Mar 28, 2008
    #1
  2. wisemx

    wisemx

    You using classic ASP or asp.net ?
     
    wisemx, Mar 28, 2008
    #2
  3. wisemx

    wisemx

    wisemx, Mar 29, 2008
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    This is a known issue with Access 2007.


    Access is designed to be used as a desktop database. When you password protect the DB, Access 2k7 creates some sort of encryption key that is stored on the currently logged on user's profile. This is no problem when you use Access on your desktop because you always have a valid profile.


    When you try to use this on the web application, the database driver will automatically try to create the temporary key in the ASPNET user's profile which DOES NOT exists. As of currently, I don't think anyone figured out how to tell the database driver to use the machine keystore.


    Long story short, you can't use password protection w/ Access 2007 when using it for web application.


    I recommend upgrading to SQL.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 29, 2008
    #4
  5. wisemx

    wisemx

    I had no idea 2007 did that, thanks bro.
    For Siemens I did exactly what was discussed here for employees who travelled.
    Since then I've only used Access 2007 to open previous Access DBs.
    Having done so much with them this kinda shocked me. [​IMG]
    Thanks
     
    wisemx, Mar 29, 2008
    #5
  6. davherb

    davherb

    classic.

    I am moving an application from another web host.

    Works fine without a password, but it seems like it ought to be password protected.

    Dave
     
    davherb, Mar 29, 2008
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page