Sunday, October 10, 2010

The right to use DAO or ADO to access Access 2000



When you use DAO to access Access 2000, does the following error message?

"Run-time error 3343 Unrecognized Database Format XXX"

This error message has two ways to solve:


1, if you are using the Data Control to connect Access 2000 database when:

You must set the Source Data Control with a line before

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

2, if you quote "Microsoft DAO 3.51 Object Library" to access the Access 2000 database when:

To join parts銆?銆怭roject銆?銆?Microsoft DAO 3.6 Object Library"

If you are using ADO access to Access 2000 in VB6 in the past, using ADO OLEDB Provider 3.51 using the Access 97 database, the program can be normal since the sash 5 is a small Access 97 After Upgrade to Access 2000, you can not facilitate the use of information on Access 2000 library, and do not know whether you have encountered such a problem?

In fact, this kind of thing Microsoft is already thinking accustomed to seeing things the air! Any software as long as a new version and old versions will be incompatible with the problems arise!

This time because of Access2000 has been used Jet 4.0 Engine, so solutions of Q as follows:

In your ADO the Connect String in the Provider must be revised: "PROVIDER = Microsoft, Jet.OLEDB.4.0"







相关链接:



Guide Helpdesk And Remote PC



Video P2P download Storm: Openext



brief Audio Presentation Tools



SA118 translation (8)



RUP tailoring principles and cutting process



Improvement of the current financial report



Who cuts should be cut? Old staff or new staff?



WIZARD Games And Entertainment



MKV to DivX



Utilize ALL practical use of small floating window all captures Thunder 5.9



Runtime error 28 you must try this



M2TS to MOV



Ma Left Here Mind: To Be The Only Child



ASF to MPEG



Mito Xiu 1 Minute Transfiguration "Impressionism" Photo



No comments:

Post a Comment