Use DAO or ADO to Access 2000 correctly

When you Access 2000 using DAO, will the following error message be displayed?

"Run-time error 3343 Unrecognized Database Format XXX"

There are two ways to solve this error:

1. If you use Data Control to connect to the database of Access 2000:

You must add a line before setting the Source of Data Control.

Set Data1.Recordset = rsDAO36 'rsdao36 is a DAO 3.6

2. If you reference Microsoft DAO 3.51 Object Library to Access the database of Access 2000:

To join the project] Part: Microsoft DAO 3.6 Object Library 」

If you used ADO to Access 2000 and used ado oledb Provider 3.51 to use Access 97 database in VB6 in the past, the program would be able to perform a normal failover 5 since you upgraded Access 97 to Access 2000, you cannot use the Access 2000 database. I wonder if you have encountered such a situation?

In fact, this kind of thing is already a fantasy in Microsoft! Any new version of software may be incompatible with the old version! This time, the Access2000 has used the Jet 4.0 Engine, so the Q solution is as follows:

The Provider in your ADO Connect String must be modified: "PROVIDER = Microsoft, Jet. OLEDB.4.0"

(