Store Images in a Database

I have seen lot of queries about “How to insert an image into database as well as retrieve an image from database?” at Developer Fusion’s forum. I have developed an “ActiveX DLL” which will work on Microsoft Access Database.

The name of that ActiveX DLL is “ADOPictDB32.dll”. ADOPictDB32.dll one Sub Procedure and one Function

• putPict(ADODB.Recordset, Database Fieldname, Temporary Filename)
  
• getPict(ADODB.Recordset, Database Fieldname, Temporary Filename) as String

Here putPict is the Sub Procedure, which takes an ADODB.Recordtset object as 1st argument, Database Fieldname in which the picture will be held as 2nd argument and the temporary filename as 3rd argument (this will held the picture file temporarily). The Sub Procedure putPict is used to put picture into database.

getPict is a Function which takes 3 arguments same as putPict () Sub Procedure but return the filename. getPict is used to get picture from database. The Database Type is Microsoft Access

The Database structure that I have used is given below

Field name	Data type
Pid	Auto Number
Pict	OLE Object

You must add ADOPictDb32.dll as Reference to the Project.