[dreamesmaster_eg]

hi
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"

[messirayn]

i am not sure and i am new to vb6 but i have read in a post earlier that some VB's doesnot work with
access 2010. it works only when you save the database as access 2000(.mdb) or access 2002-2003(.mdb) file in access 2010

[BobRodes]

start here: http://msdn.microsof...precatedMethods