Results 1 to 2 of 2
  1. #1
    David92595 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2012
    Posts
    22

    How To Store Attachments

    Hello,

    Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end.



    I need to find a way to attach documents via my access front end. I've done some research and there seems to be quite the debate about how this should be done.

    I don't have a full understanding about the subject, so any help as to the best means to accomplish my goal would be greatly appreciated.

    Thank you,

    David92595

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I thought SQL doesn't have Attachment type field.

    Have a field in SQL table that stores a string that is path to external file. Use code in Access frontend to open the file. If the file is an image, can use Image Control to display the image in report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Store backend on NAS?
    By justgeig in forum Access
    Replies: 1
    Last Post: 04-19-2012, 06:59 PM
  2. Replies: 1
    Last Post: 07-25-2011, 08:27 AM
  3. How to store data many row in one table
    By dododo in forum Access
    Replies: 4
    Last Post: 06-25-2011, 12:42 AM
  4. Two colunms in combo, only store one?
    By Bike in forum Queries
    Replies: 3
    Last Post: 03-30-2011, 10:38 PM
  5. How would you store this?
    By techneophyte in forum Programming
    Replies: 1
    Last Post: 08-16-2010, 09:09 AM

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