Using Update Query with Attachment Field

Creating a database to store information on clients and the documents we keep on each client. I made a big mistake and set the database up with tables for each document type with their attachments and the information we input on the document.

I had a bunch of tables connected to the client information table in 1-1 relationships so I went to combine it in one big table.

[sidenote: I read that this was horrible database design to have it spread out in tables with 1-1 relationships plus it's keeping me from inputting the information in one form because the client itself has to be inputted before I can input the documents since the document tables pull from the client name which isn't established whenI try to put it in at once.

If I'm really not that in the red with having multiple 1-1 tables then I'd love it if someone could help me make a form that would let me put in the clientinformation and the documents at once with out running into the issue of the form not knowing to create new records in the document tables with the name of the client automatically in there]That's where I'm hitting my issue;

I've been using an update query to move over the text/date/number information from the documents tables to the new master table but it won't let me transfer the attachments I've attached because it's considered a multi-value field.

We've already populated the thing and so it would really suck to have to go through by hand and re-attach the thousands of documents.

Sponsored Links:

Related Topics

Updating records with attachment fields
I maintain a 9 year old database which I recently converted to Access 2007. While doing so, an attachment field was added to one of the tables.
My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update query came back with a message to the effect that you can't use an attachment field in an update query.
Has anyone else encountered this problem? If so, what is the workaround? VB or manual re-entry of the data


Attached Files
I created a database with an attachment field that is working fine. But for future use, we will be using a SQL database so the attachment field, which is not supported in Microsoft SQL 2005 will become useless for our ASP.Net application. I would like to keep using the attachment filed in access, but I would like to add the actual file name to the table as well without having the user add it.

I can see the attachment FileData, FileName and Filetype when I go into query view, but when I attempt to create an update query that will take the FileName and populate the new field, I get an error that states
Enter Parameter Value with the ReportAttach.FileName below.

Does anyone know how I can get the Filename into a new field


Updating records with attachment fields
I maintain a 9 year old database which I recently converted to Access 2007. While doing so, My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update querycame back with a message to the effect that you can't use an attachment field in an update query.
If so, what is the workaround? VB or manual re-entry of the data?


Add an attachment to form
I am trying to add an attachment to a subform. I update the control source to say "Attachment" in the properties section which matches the name of the field in the table where it's pulling from.

When I open in form view and right-click on the text box (for attachment) the manage attachments selection is greyed out. If I go to the table I can open the attachment.

Any idea why this isnt working in the form


Updates to Attachment doesn't trigger After Update macro
I want to save all information from a table row into a historyTable when an update is made to it (to be able to view the history of the table).
However the table contain one field of data type Attachment and changes to this field doesn't seen to trigger the After Update macro.

How do I save changes to an Attachment data type?
I want to use a macro directly from the table rather than using code triggered by the update form since I don't want the history saving to be bypassed by people making updates directly to the table.
The attachment itself doesn't have to be resaved, but I want the history table to show that a change have been made


Add multiple records with one field
Please find attached my form, the "Slide" field is of type attachment. This field usually has min 5 attachments, is there a way that a record can be made for each attachment added, the Start and End Date will be the same for every attachment.

Can someone please help, it takes a long time to add each attachment seperately.


How do I make an attachment name appear while working in a form (Access 2007)?
i have created a form to describe digital photographs (JPGs) attached to my database. Along with the attachment image, I've also added a field that displays attachment name.

However, this field is not populated until I close and reopen the database.

How can I have the form display the attachment name as soon as the attachment is added?


how to use select * from where tblFileImport.bulletin_imp.FileData Like
I don't know how to do this search. I have bellow this query based on 2 tables where the second table has an attachment field. The searching should be based on the content of the attachment,for ex: if the files(that are stored in the attachment field) contain a word like "tracking" then I want to pull the attachments and their data.


attachment type field in a subform
I am using an attachment type field in one of the tables. I have a query on this table that and I would like to use it output as a source data for a subform.

Here where the issue is: it seems that I can't add one field representing the file to be visible in the form.
There is number of file metadata such as: .FileData, .FileFlags, .FileName, .FileTimeStamp, .FileType, .FileURL.

I would only like to display an icon, or a filed representing the attachment.


Attachment data type and VBA
I'm trying to create one record from another one. One field is attachment data type. I just create a normal query (INSERT INTO) but it' not working (impossible with multiple value field). Do you have a suggestion about inserting or updating an attachment datatype field (with or without VBA


Remove specific type of attachment from all records in table
I have table call "empTable" and it has an Attachment field called "Attachment". Some of the records has empty Attachment field and some record has one attachment and some has two and the attachment types are jpeg and pdf.

I want to remove all the pdf from all the records in this table automatically with VBA or something,


Save Report in Attachment
I have a Exam DB where we genreate the Question papers as rtf ( M S WORD File). We have to attach the above file manually to our attachment field
Table:Exam_Papers
Attachment Field:Privious_Papers
Can this be done through code automatically?


Attachments in sub-form in Access 2007
I have a table (Reports) that holds some descriptions of some reporting, and then an attachment field that holds the report itself. (I know I should probably be using a hyperlink, but the attachment field is more convenient). Then I have another table (PersonnelReports) that holds a Many-to-one relationship with my main table (Personnel), but calls up the data from the Reports table. I have a query that pulls the correct data out of the Reports table for each Personnel, and then I use a sub-form based on that query to display the details of the report. But the sub-form won't display the attachment field, even though it exists in the query.


Attachment control on form
Can the attachment control store the attachment on a hard drive and not embed in Access? I created a db with this feature and now the db size is reaching 2 GIG . It is the attachments. If I remove the attachment field in the table it shrinks to 55mb.

I thought the attachments was just a link to where the picture reside but apparently it is embedding the picture.


Manage attachments
I have a form in which the fields are enabled or disabled based on user permissions. If a user has only 'Read' permission then all the fields are disabled else the fields are enabled. Now I also have an attachment field in my form. If I disable the attachment field, then the user is unable to view the attachments. I want the users with 'Read' permission to view the attachments but not manipulate it. Like, a user with 'Read' permission must not be able to 'Add' or 'Remove' an attachment, but he must be able to 'Open' the attachment and 'Save' the attachment.

P.S: I have used the default 'attachment' which comes with MS-Access, that is I have added a field with the datatype 'attachment' and made my textbox a bound field in the form


attachment fields
Previously using Access 2003 now using 2007 for the first time - was using a text field for paths to images for displaying on forms, now I see there are attachment fields that seem to be for images. Question is how do I convert the text field into an attachment? Or should I even be trying


Attachments (fields)
I would like to create an attachment field in a table that I can use in a form. When I try to create a attachment field I am going to datasheet tab/ data type & formating/ data type clickon the drop down list and no option for attachment in design or data sheet view is their a setting or something I need to setup?


automatic attachment file
I'm using Access 2007 and the attachment data type on a form, but it would be nice not to have to browse to the file I want each time. Is there a way to automatically retrieve the file I want for the attachment based on the file name being written in a different field on that form? For example, for each record, there is a .jpg file to be attached. All of the .jpgs are stored in the same folder, so that path would always be the same except for the file name itself, which would be the contents of another field with .jpg added on the end. I still want to be able to edit attachments or add other attachments to each record, but the .jpg attachment will always be there.


Bring up attachment box programmatically
Is there a way to get the attachment box window to come up using VBA, I only need the standard window that is associated with the Attachment datatype when you double click the field on a form


Change Image with a combobox
I have a query which links two tables, its a Group By query. In one of the tables which links to this query is a attachment field(for Images). I have a form which I have based on the query and details of this forms get updated with a combobox.

How can I link the attachment file from Table 1 on to this form and I want the images to change as the records are changed.