how to change ms access database password in c#?

Hot Topic

Validate xml through the embedded resource DTD
DataSet Nested Rows
Referencing Assemblies Through Code
Problem making HTTPWebRequest from within Web Service
Problem with decrypting data
Uploading file to server
Communication between apps via sockets.
DataTable.Load() Generates InvalidOperationException
.Net 3.0 installation
Website

.NET Development

XSLT compile error when using XslCompiledTransform.Load indirectly called from unmanaged code.
App works in debugger, not otherwise
Very Basic Question - Sorry
Target the Framework version and Redirect Assembly Bindings from 2.0 to 1.1
NegotiateStream...Server rejecting client credentials
How can I load a big image file to an Bitmap object?
Microsoft.XMLHTTP Problem...
Data provider could not be initialized
How-To (Object Class => Binary Serialization => To Memory => Encrypt => Save to File)
Application Blocks

how to change ms access database password in c#?

hi,

how to change the ms access database password in c# i search through the web and found one in VBA but not in C#. http://support.microsoft.com/kb/170961

Please give some hints. Thank you.

regrads,
chunket

Answer this question

how to change ms access database password in c#?

  • Evan Mulawski

    I doubt it's possible.

    Charles

  • schmod54


    First you need to open the database for exclusive access. Below is a sample connection string:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test Files\Access2000.mdb;Jet OLEDB:Database Password=currentpassword;Mode=Share Exclusive"

    Then you can execute the following Jet SQL (ExecuteNonQuery):

    "ALTER DATABASE PASSWORD newpassword currentpassword"



  • Jonas.S

    How I can clear password or set blank password
    Can I use password with blank

  • acf


    Yes, I believe you specify the new password value as Null.

  • John Mathews

    bump - still awaiting reply

  • pasha2k

    Thank a lot. I'm sorry, I forgot about "specific" qoute "`" in Access.
    ALTER DATABASE PASSWORD `currentpassword` `` - set password
    ALTER DATABASE PASSWORD `newpassword` `currentpassword` - change password
    ALTER DATABASE PASSWORD `` `newpassword` - clear password
    All work fine.
    Which limit for passord (length, symbols) (when I test I can create password with 20 symbl.)
  • how to change ms access database password in c#?
Answer this question