Change Access DB Password RRS feed

  • Question

  • I writing a C# app that relies on an Access database for info.  I have password protection on the database and have no trouble opening it.   However, I want to allow the user to change the password when they so desire.  After searching google for awhile, I have found some promising code but It throws the exception:  "Cannot change password on a shared open database."

    I then seen some code on another forum that said to format the connection string like: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"strDataSource "';Mode=Share Deny Read|Share Deny Write"

    A guy wrote on that foumn and said that when he trys to change the password to a new one, he gets an error saying that the password isn't valid.


    What is the proper way in which to change a password?

    Monday, July 9, 2007 5:17 PM