Tuesday, September 8, 2009

Non-ADO Problems Data Access Visual Basic 6.0


Control Data in Visual Basic 6.0, is basically designed for the Jet 3.51 database engine, the Microsoft Access 97. But now Microsoft Access database has been enhanced by the passing of Microsoft Access 2000 and XP with Jet 4.0 engine. Control data were not able to handle the connection relationship with the Jet 4.0 database engine or any other type.
Error message will appear if you are using Data Control by setting the record source property window with the Jet 4.0 engine is as follows:
The above error message appears because of differences in the database engine used. Microsoft Access 97 is made by using the Jet 3.51/3.6 database engine. While Microsoft Access 2000 uses Jet 4.0 database engine. Capabilities of the DAO, which is the standard data controls in Visual Basic, just to access the database engine with engine  Jet 3.51/3.6 not for Jet 4.0 engine.

0 comments:

Your Ad Here