none
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

Answers

  • 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