access97 to 2000 with vb frontend

[BarbaraR]

I have converted 97 database to access 2000 no poblems
I have converted fronted from vb5 to vb6, but when I use
the exe file to open the database it says "Unrecognised
database format" does anyone know what I need to
do...simple instructions please.

 

[GVaught]

Good news and bad news. Access 2000 defaults to ADO connections not DAO like
Access 97. It is possible that you can just set the Access 2000 db to use
DAO 3.6 rather ADO 2.1 or higher and not have to change the code. Try this
first. Remove all references to ADO under Tools | Reference when inside the
Code Editor of the Access 2000 database.

The bad news is you may have to go back through your VB 6 code and ensure a
direct code change stating you are using DAO recordsets and database
connections. I also believe you may have to reset some references within the
VB 6 project and compile. I am not sure how much a difference there is
between VB5 and VB6. When you say VB, I am assuming you are talking about
Visual Basic and not VBA, the language used in Access 2000 and above.