Could not connect to the ODBC data source driver SQL State= 42000 ODBC Microsoft Access Database Not a valid password Native Error = -1905 RRS feed

  • Question

  • Hi,

    Please help me with my problem on accessing an access database. The database (.mdb) is in production and i am accessing it through a mapped drive in my laptop. Whenever i try logging to it, it prompts :

    "Could not connect to the ODBC data source Driver = {Microsoft Access Driver (*.mdb)} SQLSTATE = 42000 - [Microsoft] [ODBC Microsoft Access Driver] Not a valid password. [Native Error= -1905]]"

    But if i copy the databse to my local drive, it works fine and i can login properly.

    I'm wondering if there is a port i need to open for Microsoft Access so this will work. Or any idea what could be the cause of it?




    Saturday, April 17, 2010 12:24 PM