Add image in Data Base

Good Day Guy's. This infomation for those who is in the involved development sector.Today i want to tell you about the procedure How to save image or Bitmap in a data base.

You can display images, such as pictures and photographs, on your forms and reports. Access provides several ways to store images.

Way of Link to images in a database table

·If you haven't already, add an OLE Object field to an existing table, or create a new table and add an OLE Object field.

·Insert your image files into the field. During that process, you choose whether you link the image.

·Open the table in Design view

·In the first blank row of the design tool, under Field Name, enter Image

·Click the next field (the field in the Data Type column), and select OLE Object from the list.

·Save the table

·Close the table in Design view, open it in Datasheet view and go to "Add images to the OLE Object field later in this section

·Open table in design view.

·Enter Image in the Field Name column, and select OLE Object from the list in the Data Type column. Save the table.

·Close the table in Design view, and then open it in Datasheet view

·Continue to the next set of steps, "Add images to the OLE Object field .

Add images to the OLE Object field

1.Right-click the first field in the column of the table and click Insert Object.

2.Click Create from File, and then click Browse

3.Browse Windows Bitmap images.

4.To link to an image, click Link, and then click OK again to complete the process. To embed the image in the table, leave the Link check box blank and click OK.

5.Go to the other fields in the Image column and repeat steps 2 through 5 until you've added the desired images.

Thanks:

Alex_tom