Create a field to store paths to pictures

Microsoft Office Access 2003

  • 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.
  • 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.

  • Caution  Users of your database or data access page will be able to view the image paths. You might want to make sure that the paths do not include personal information, such as your name or the name of your computer.

    ShowTip

    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.