Solved

How do I export attachements from one table to another in MS Access

Posted on 2015-01-17
3
110 Views
Last Modified: 2015-01-18
For some reason all the attachments have disappeared from a database, does anyone know how this can happen? This database has been successfully running for 8 years and this has never happened before, however I do know the company are now running it from a Mac so I wonder if its anything to do with this?

Also, I need to export the attachments from a backup database does anyone know how I can do this?  I have tried with an update query but it didn't work.

Please note I do not do coding, so is this possible through a query?

Thank you.
0
Comment
Question by:LillyC
  • 2
3 Comments
 
LVL 57
ID: 40555338
When you say attachments, is this actually an attachment data type field that your working with?  Assume yes, just want to be sure.

Jim.
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40555362
By the way, if the answer to that is yes, then our stuck with coding.  There's a sample DB here:

http://www.accessmvp.com/thedbguy/demos/mvfattachment.asp

That you might be able to work with and use to move the data around.

Jim.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 40556592
If that database has been running 8 years, it may use the old OLE Object type field rather than the new Attachment type field.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question