2 Replies - 6443 Views - Last Post: 09 September 2011 - 11:47 PM Rate Topic: -----

#1 dreamesmaster_eg  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 06-September 11

error "Unrecognized Database Format" When using Access 2007

Posted 06 September 2011 - 10:00 AM

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"

Is This A Good Question/Topic? 0
  • +

Replies To: error "Unrecognized Database Format" When using Access 2007

#2 messirayn  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 09-September 11

Re: error "Unrecognized Database Format" When using Access 2007

Posted 09 September 2011 - 12:14 PM

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
Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: error "Unrecognized Database Format" When using Access 2007

Posted 09 September 2011 - 11:47 PM

start here: http://msdn.microsof...precatedMethods
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1