locked
VB6 - Access 2003 Password Error RRS feed

  • Question

  • Hi

    I have a VB6 application that connects to MS Access 2003 DB using ADODB . We have migrated to Windows 7 (64 bit) from XP and now I am getting the Error 3031 - Password Not Valid. A sample of the connection code is below

    STRING_DB_ATTRIB = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & SERVER_LOCATION & DB_PATH & ";"
    Set mCon = New ADODB.Connection
    mCon.ConnectionString = STRING_DB_ATTRIB
    mCon.Properties("Jet OLEDB:Database Password") = DROWSSAP

    mCon.Open

    Any ideas please?

    Thanks in Advance

    Tuesday, March 25, 2014 3:15 PM

Answers

All replies