can anyone help me in this error
i'm using vb6(sp6) & Access 2010 (database extension .accdb)
i'm using this reference in my project: Microsoft Office 14.0 Access Database engine object Library
in the past when i was using Access 2000 my code was like this:
Set db = OpenDatabase(App.Path & "/mydb.mdb", False, False, ";pwd=mypassword") Data1.DatabaseName = App.Path & "/mydb.mdb" Data1.RecordSource = "select * from mytable ;" Data1.Refresh
now it's not working even when i using the refernce "Microsoft Office 14.0 Access Database engine object Library" instead of "Microsoft DAO 3.6 Object Library"
and changing the extension of the database in the code to".accdb"