Solved

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

Posted on 2015-01-17
3
114 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

791 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