-
We are in the process of converting our databases, which are used by VB 6.0 applications, from Access 97 to Access 2000.
Apparently, you have to switch from DAO controls to ADO controls in VB 6.0 when the program is accessing Access 2000 databases.
This is causing us a lot of grief and frustration as ADO controls and their methods and properties are very foreign to us.
Does anyone have a guide to follow when doing this?
IE: Which Reference Libraries to use, which controls need to be used and which controls should not be used....etc
Any assistance of any kind would be greatly appreciated.
-
DAO 3.6
Anyway, you still can OPEN, EDIT, DELETE the MS Access 2000 database's records with the DAO 3.6 object. it is not necessary must be change all your code to ADO.
Although ADO have much more new feature, but sometimes it may very slow in connectin the database. (You need to handle it care).
As i read some magazine, they recomended the user to stick back to DAO when they performing migration process from DAO] to ADO and switch to ADO object for those just start thier database application. :)