How to allow user to read application if MS Access protected password is given correct in Windows C#

Question

Hi,

i am using Windows application.

my client want to set password in MS Access DB.

When end user selecting the file from browse button, system should check the password and set password somewhere in the application.

if the set password and Access password is match then system allow further process.

How to do this in Windows C# applications.?

Answer 1

Hello Gani tpt,

You could try to use OpenCurrentDatabase to open a database with a password.

Here is the example code.

 Access.Application application = new Access.Application();
            application.Visible = true;
            application.OpenCurrentDatabase(filepath: @"C:\Users\terryx\Desktop\TestFolder\Database1.accdb", bstrPassword: "123");

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Thanks..