Adding Digital Files to a Database

Digital files such as image and sound files can be inserted into a database.

Collect digital sound and image files of each of your friends in your Address database.

Open the table that contains the address details.

Go into design view.

Add two new fields called voice message and photo.

Set the data types for each to OLE Object.

Go back into form view.

In a cell under the new field simply right click and select insert object.

Select the Create from file option and then browse to the location of your sound or image file.

To view or listen to your files you will need to create a new form that contains the voice message and photo fields.

The photo field contains an image of the person and the sound field contains a sample of music. By following the step above i have been able to successfully add a photo and music into a form.