Results 1 to 2 of 2
  1. #1
    freds is offline Novice
    Windows 7 Access 2007
    Join Date
    Nov 2009
    Location
    AZ
    Posts
    1

    Attachment Field problems


    I have created a small simple database with fields for first and last names and an attachment field for pictures. This is for a photo directory of members of an organization.
    I tested the program using family pictures until I had everything working.

    I deleted all data and then started entering member data for the directory. Now for the problem. As I add a new record, an old family picture shows up until I add a new picture. My question is how do I initialize the attachment field?

    Any help would be appreciated. Thank you

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows XP Access 2003
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I am not sure whether you have used hyper-links or OLE (Object linking and Embedding) field type, but what ever I could make out from your post it is OLE field. there are 2 ways to attach a photo to this field 1. Linking 2. Embedding. It seems that you have linked the pictures and thus although you have deleted the source files the pictures reappear.

    you have to delete the link from the picture from the table permanently and only deleting the source files will not do the trick. if you have linked the pictures the photograph will be displayed even if you remove or delete the source files from its specific directory.
    thanx my email silverback_bats@yahoo.co.in

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How To View Hyperlink For Attachment File
    By treyprice in forum Access
    Replies: 0
    Last Post: 07-28-2009, 12:51 PM
  2. Beginner trying to send email with attachment
    By ahm in forum Programming
    Replies: 2
    Last Post: 03-24-2009, 08:51 PM
  3. email attachment from Access
    By Gandalf in forum Queries
    Replies: 0
    Last Post: 01-22-2009, 10:03 AM
  4. Replies: 0
    Last Post: 01-08-2009, 05:49 PM
  5. Problems with autonumber field in a form
    By admaldo in forum Forms
    Replies: 0
    Last Post: 02-25-2008, 11:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums