Connection string RRS feed

  • Question

  • Hi all

    I am trying to connect to Access 2007 DB with an exclusive password, nirvana

    The followin is my connection string,

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Documents and Settings\Database1.accdb;Exclusive=1;pwd=nirvana

    However I am not able to connect to the database. It keep prompting me "Could not find installable ISAM"

    Pls advise

    Thursday, December 23, 2010 7:26 AM


  • For a database password, you need

    Jet OLEDB:Database Password=nirvana;

    I don't know about the Exclusive setting. Yours could be right - I suspect

    Mode=Share Deny Read|Share Deny Write;

    says something different.

    Peter Jamieson
    • Proposed as answer by Bruce Song Monday, December 27, 2010 6:38 AM
    • Marked as answer by Bruce Song Tuesday, December 28, 2010 2:55 AM
    Thursday, December 23, 2010 9:12 AM

All replies