Hi, I am getting an error when attempting to connect to an Access Database in Excel. It prompts me to enter a password when connecting and then I can view the tables, but when I return the data to Excel it give me an error:

ODBC Microsoft Access Driver Login Failed
Not a valid password

Does anyone know why I am getting this error? I am definately entering the correct password.