Open MS Access file protected with password

Question

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

Mohammed Gamal · Answer

No Only it is succeed when I make a test connection But when I run the application and enter the username and password it gives me error  not valid password

sanjeev pandey · Answer

Is your problem solved?

Mohammed Gamal · Answer

Sure 1st I created this password 2nd I make a test connection And it is success

sanjeev pandey · Answer

hi gamal actually i want to know if you know the access database passord?As u have mentioned- 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 .