If the user clicks the OK button, then the Load event handler’s call to ShowDialog returns OK. The password form’s OK and Cancel buttons have DialogResult properties set to OK and Cancel, respectively. (See the picture at the top of this post.) That form simply contains a password text box and OK and Cancel buttons. OleDbConnection conn = new OleDbConnection(connect_string) ' Jet OLEDB:Database Password=' + password String db_name = Application.StartupPath + This assumes it's in the executable's directory. 'Picture', 230, HorizontalAlignment.Left, If (frm.ShowDialog() = DialogResult.Cancel) Close() Private void Form1_Load(object sender, EventArgs e) When this example starts, the following Form_Load event handler executes to get the database password. Download that example to see details about how the program loads data from the database into a ListView control. This example is similar to the example Display database pictures in a ListView control in C# except it uses a password protected Access database.

Otherwise search the internet for instructions for your version. If you are using another version of Access, you may be able to find features similar to those described here. Enter and verify the password and click OK. Select the Info tab and click Set Database Password. After you select the file, click the dropdown arrow next to the Open button and select Open Exclusive. To do that, press Ctrl+O and browse for the database file. In Access 2013, first open the database for exclusive use. The details for making a password protected Access database varies depending on the version. Making a Password Protected Access Database For example, you could use a similar approach to provide a login for an Oracle, SQL Server, MySQL, or other database.īefore I explain the example’s code, I should tell you how you can make a password protected Access database. In any case, this program demonstrates a general technique that you can use with other kinds of databases. For more information, see the Stack Overflow post Access mdb password recovery. Different versions of Access databases use laughably simple security so it may be possible to recover their passwords by simply looking in their headers. There are several program available for download that claim to recover lost passwords. Note that the security used by a password protected Access database may not be very secure.

It also shows how you can use the database’s password protection to provide a login form for your program. This example shows how you can open and use a password protected Access database in C#.

Ms access password connection string