either you have typed the name (and or path) of the database file incorrectly
I don't think because I'm using the default dialog box to select the database

Then I enter the correct password, I choose jet 4.0 . But when I click test Connection, i get this error:

"Test connection failed because of an error in initializing provider. Can't start your application. The workgroup information file is missing or opened exclusively by another user."
if i drop the password, the connection works but i need to have my database protected. by password.