connection string for opening an access db with a password read-only RRS feed

  • Question


    Should be simple but I am having a hard time finding an exmaple.


    What I need to do is open an access database with oledb that has a password that resides on a DVD disc -- so it needs to be able to be opened read-only.


    An example for the connection string would be most appreciated.

    Wednesday, June 11, 2008 12:27 AM


  • You could try


    Code Snippet

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\filename.mdb; Jet OLEDB:Database Password=[PWD]




    Replace [PWD] with your password and you'll connect to the database. Don't worry about the readonly, if you are trying to update it, it will notify you Smile




    Wednesday, June 11, 2008 4:54 AM