by Paul Mather (15 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Beginner
Date Added: Wed 3rd February 2021
Rating: (15 Votes)
This will allow you to get BMPs (only Bitmaps) from an Access database using ADO. Officially, Microsoft says this about it in MSDN:
INFO: Issues Migrating from DAO/Jet to ADO/Jet
ID: Q225048
OLE Container Control
Many databases, including the SQL Server 7 Northwind database, contain pictures and other objects saved by Microsoft Access. In Visual Basic, you can see the pictures by binding the OLE Container control to the DAO Data control. However, the OLE Container control is not compatible with the ADO Data control and there is no way to access these pictures and display them using ADO. The OLE Container control cannot be used unbound because GetChunk does not retrieve the data in a format compatible with the ReadFromFile method.
Please Vote!