How to access a password protected MS Access database
-
I want to open a password protected database in vc 6 program but it do not works following is the code (if db has no password then every thing works fine) m_pConnDB->Open (_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; \ Data Source = Database1.accdb"), \ _bstr_t (""), \ _bstr_t (""), \ adModeUnknown); I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work I have also tried same code on MDB file instead of accdb files but still same error. Thanks in advance
-
I want to open a password protected database in vc 6 program but it do not works following is the code (if db has no password then every thing works fine) m_pConnDB->Open (_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; \ Data Source = Database1.accdb"), \ _bstr_t (""), \ _bstr_t (""), \ adModeUnknown); I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work I have also tried same code on MDB file instead of accdb files but still same error. Thanks in advance
pc_dev wrote:
I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work
Probably the wrong format for the password-argument, see connectionstrings.com[^]. I expect something like this would work;
_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = Database1.accdb;User Id=admin;Password=blabla;")
I are Troll :suss:
-
pc_dev wrote:
I have also tried "Jet OLEDB:Database Password = mypassword" but it dont work
Probably the wrong format for the password-argument, see connectionstrings.com[^]. I expect something like this would work;
_bstr_t ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source = Database1.accdb;User Id=admin;Password=blabla;")
I are Troll :suss: