How to reset MS Access' password through VB.NET?

Posted on 2008-11-20
Last Modified: 2013-11-29
As a request from our client, we have to change the password of an existing local access database through a VB.Net & VB6 windows application.

Is it possible?
Question by:stephenlkb
    1 Comment
    LVL 84

    Accepted Solution

    Assuming you know the password, and assuming you're referring to the Database password, you would do this (in VB):

    Dim dbs As DAO.DAtabase

    Set dbs = DAO.OpenDatabase("Full path to database")
    dbs.NewPassword "Old Password", "New Password"

    I'm sure there is an equivalent method in .NET, but I don't know it.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    It is a common problem that often server suffers from the lack of space on system volume. Old servers or new ones from vendors come with preformatted small volume - 5-6GB in total and after installing updates or applications the free space on system…
    I wrote an article ( some time ago with a reference to nLite  ( software.  I recently changed that link to point to NTLite (https://www.ntl…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now