VB and Access 2000 Error 3343

[frnk]

I recently converted my Access 97 database to Access 2000 format.

My 32bit VB4 program now will not see the new format. The following
gives an error "Runtime error 3343 - Unrecognizable database format"

Set dbs = OpenDatabase(dbname)
Set rst = dbs.OpenRecordset(tblname)
Set qdf = dbs.CreateQueryDef("", sqlx)


What do I need to access the 2000 format from vb4(32bit)?
I converted my vb4 program to vb5, tried using the DAO...same error.
Is there a new dbengine or *.dll for Access 2000 and vb ?

[JHausmann]

You'll need to reference DAO 4.0 and not 3.5 in order to access MSAccess 2000.

[SmithVoice]

Isn't it DAO3.6 for Jet4?

(BTW: even the updated DAO may not completely end your issues. If you use DAO datacontrols then you can not drectly read Jet4 table structures. For details and the MS "Workaround-sort-of" see:
http://www.smithvoice.com/access.htm
)
-Smith

------------------
http://www.smithvoice.com/vbfun.htm

[frnk]

Thanks to both of you for the info. DAO 3.6
did the job with vb4 and vb5 for what I've
been doing. However, the posts I've read in my research lately gives a very grim picture of vb/access2000. Hopefully Microsoft will give us back the DAO capabilities we had with office 97. It appears MS wants to go ADO, but the stuff I've read says it's not so hot.

Thanks again for the info.

[JHausmann]

Yeah, 3.6, that's the ticket. Actually, I have neither Access 2000 or Jet 4.0 but I knew that Access 2000 could not use the 3.5 drivers....

[This message has been edited by JHausmann (edited 09-16-1999).]