Wrox Programmer Forums
All Other Wrox Books Do you have a question about a Wrox book that isn't listed anywhere on p2p.wrox.com or where the forum is locked? Here's a forum to post questions about any other Wrox book so that other readers or one of the authors can help you with your questions. IF YOU ARE LOOKING FOR CODE DO NOT ASK "Where can I find the code for this book?" That question is answered here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the All Other Wrox Books section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 27th, 2009, 06:55 PM
Registered User
Join Date: Jul 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ms access 2007 Attachments

Hello All,

There are volumns of words about why you should not attach images in a database in regard to "Bloating and overall limitations". I do not have an issue with the 2GB limitation for my particular application and I would think that many other non-commercial users of Access 2007 would either. Example: To test my application, I loaded 1650 individual (640x480 JPG's) at an average of 30KB each, for a total of 61MB, as Attachments to some 450 Records. The following is an abbreviated posting to several Forum's with little or no response to the following question.

Discussion: In Access 2007 when using the Attachment field you can list one or more (image/icon/text/) files. I have an Attachment field on one of my data entry Forms that primarily displays a JPG image. Under Properties I have listed a path to a Default Picture (it works great). Using the Manage Attachments dialog box I can add one or more files of my choice to any given record. Once a file is added it overrides the Default Picture (as expected). If I list multiple files I can view them with the default Mini Toolbar. Whichever JPG I select will be displayed in the Attachment field (rendered image or icon) and will remain displayed as I work in other fields on the form.

Problem: However, when I move to another record or close the Form, the “displayed” JPG will not be saved in this position as the default file. When revisiting the record, the underlying binary table will revert back and display the original JPG (the normal order of ascending file structure; 1.jpg, 1a.jpg, 1b.jpg). Adding or deleting files makes no difference as the binary coding sorts to the lowest collating sequence name and displays that file(image). The Manage Attachments dialog box does not provide the user an option of selecting a specific file, if more than one is available.

Dilemma: I have a report that is generated from this form that provides selective fields of data and “hopefully” a specific image file from multiple choices associated with a record. I really don’t want to manipulate file structure or create a separate table to store files or use a List/Combo Box to achieve my desired goal.

Any assistance would be greatly appreciated. Thank you for time.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Script Editor in MS Office 2007 sektor VBScript 1 June 28th, 2010 04:44 PM
Connecting MS Access 2007 with C++ curiaquita Visual C++ 0 February 3rd, 2009 01:59 PM
Read data from Ms Excel 2007 senpark15 C# 2005 3 June 21st, 2008 02:35 AM
Leaked MS Office 2007 Documentary? kohlerwoorx Access VBA 3 April 9th, 2007 08:44 AM
Leaked MS Office 2007 Documentary? kohlerwoorx Access 2 April 9th, 2007 08:42 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.