Create a field to store paths to pictures

  1. Create a field in a table and set the field's data type to Text in a Microsoft Access database or varchar in a Microsoft Access project.
  2. In Datasheet view, type the path to the image (a .bmp, .jpeg, .gif, .dib, .wmf, or .emf file) in the field you created.

    If you will be sharing the Access database, you might need to specify a UNC path.

    If you will be displaying the pictures in a data access page, you might need to specify a URL to a valid Web address.

Tip

You can use relative paths to store pictures. For example, if the Access file is located at \\ServerName\ShareName\ and the pictures are stored in the folder \\ServerName\ShareName\Pictures, you don't have to specify the entire path such as \\ServerName\ShareName\Pictures\PictureFileName.gif for a picture that you will display in a form or report. You only need to store the portion of the path that is different relative to the location of the current Access file รน Pictures\PictureFileName.

If you want to use relative paths to store the locations of pictures that you will display in data access pages, those paths must be relative to the location of the data access page, not the location of the Access database or Access project.