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

Posted on 2008-11-20
Medium Priority
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 23002739
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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 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