access 2000 database 1

[bros]

I got run time error "3343", unrecognized database format
when I want to open the database file.
The error occur when I convert my mdb file from access 97 to access 2000

I'm using vb6 to open the database
Set ws = CreateWorkspace("", "admin", "&quot
Set db = ws.OpenDatabase(app.path & "\x.mdb&quot

pls help me to solve this problem. Is Access 2000 can not link to vb program????
tq

 

[huntjr]

Check your references. You may be trying to use an older version of JET that will work with Access 97. If you try to open an Access 2000 dB in 97, it should give you an error. That may be what jet is trying to do here; it may be trying to call using an Access97 format instead of 2000.

Phil Hunt
philh@dqc.com

 

[bigfoot]

This is a common problem. Go to the ms site and do a search. It'll tell you you have to install MDAC 2.5 (I think) anyways, you can also get around this by installing VB service pack 4, and using the ADO data control.

Hope this helped. The door to life is never locked, but few have the knowledge to open it.

 

[swilliams]

I think the references are the problem. You are probably using DAO 3.51, which does not work with Access2000. Change the reference to DAO 3.6 and it should be OK.
Simon

 

[bigfoot]

ok, it's 3.6. I was not sure.
Can you use access 97 with the new MDAC, does anybody know.
I have not changed over yet. :-I

The door to life is never locked, but few have the knowledge to open it.