Open MS Access file protected with password

Mar 19 2013 6:45 AM
Hi All
i need to open A MS Access File and this file protected with a password
My Data source was "Microsoft Access Database File (OLE DB)"
my main form is a login form and after i enter the user name and password
then the form need to connect to the access file .
i face a run time error "not valid password"

private void SignIn()
        {
            #region Users_Region
            Stock_3DataSetTableAdapters.UsersTableAdapter UsersTA = new Pricing.Stock_3DataSetTableAdapters.UsersTableAdapter();
            Stock_3DataSet.UsersDataTable UsersDT = UsersTA.GetData(); // stop here
            DataRow[] UsersDR = UsersDT.Select();
            #endregion

Many thanks

Answers (4)