I have got a database which is connected to the excel were data typed in excel is sent to access. However that part works fine expect one small problem. I have got a database password to access. so when i press the command button it tells me invalid password. How do i make excel talk to access without removing the database password. is there a way where i can type the password in a code in the macro built for sending data. please help.

Thanks