Compatibility issues with win2k & win98, office 97/office2k

[adamr1001]

Hi, I have some questions...

I am developing a VP application (with VB6) that uses the Data Control with the Jet Engine tpye to access an MDB file (Access) over a LAN.

1) Will this work on Win2000 ?
2) I have tested accessing an MDB file from Access 97 and it works.... however, when i convert the database to 2000, it does not work. why?
3) anyhting else i should look out for in terms of 97 / 2000 issues?

Thanks a lot, any information would be appreiated.

Adam.

 

[Tuan3249]

Hey Adam,

To connect to an Access2000 DB, you need to use DAO 3.60. The data control uses DAO 3.51 if I'm not mistaken.

I would not recommend using the data control in an enterprise environment. There are problems with it and will cause more headaches.

There are a lot of examples of database access using Access2k on

http://www.planet-source-code.com

using both DAO and ADO.

Hope this helps.