{"id":1499,"date":"2021-10-05T14:37:40","date_gmt":"2021-10-05T06:37:40","guid":{"rendered":"https:\/\/www.yohz.com\/blogs\/?p=1499"},"modified":"2021-10-05T16:46:01","modified_gmt":"2021-10-05T08:46:01","slug":"updating-linked-file-locations-in-an-ole-object-field","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2021\/10\/05\/updating-linked-file-locations-in-an-ole-object-field\/","title":{"rendered":"Updating linked file locations in OLE Object fields"},"content":{"rendered":"

Have you ever needed to update the linked file locations in an OLE Object-type field in your database?\u00a0 Access OLE Import<\/a> can do all that for you and more.<\/p>\n

Let’s say you have a table with an OLE Object column that contains links to a file.\u00a0 In SQL Image Viewer<\/a>, you may see the following:<\/p>\n

\"\"<\/p>\n

So all the images are currently linked to files located in the F:\\Customer files\\<\/strong> folder.\u00a0 What if the files are no longer there, for e.g. when you share your database with other users?\u00a0 Your users will not be able to access the images because they may not have that folder available to store the images.<\/p>\n

\"\"<\/p>\n

Access OLE Import<\/a> can help you update the details in the OLE Object field.\u00a0 To do that, you just need to provide the key field value of the records to update, and their corresponding file location, in an Excel file.\u00a0 So for e.g. let’s say all our images are now stored in the G:\\Employee photos\\<\/strong> folder.\u00a0 Our Excel spreadsheet will simply contain the following:<\/p>\n

\"\"<\/p>\n

The ID<\/strong> column refers to the ID<\/strong> field in our table.\u00a0 The keynumber<\/strong> definition tells Access OLE Import<\/a> that this is an integer key value.<\/p>\n

The photo<\/strong> column refers to the photo<\/strong> field in our table, and filecontent<\/strong> tells Access OLE Import<\/a> we want to work with the contents of the files listed in this column.<\/p>\n

We then tell Access OLE Import<\/a> that we want to create links to the files.<\/p>\n

\"\"<\/p>\n

And that’s all there is to it.\u00a0 Access OLE Import<\/a> will update the relevant records, and the links to the images are updated accordingly.<\/p>\n

\"\"<\/p>\n

If you prefer to embed the image in the table, then select the embedded<\/strong> option instead.<\/p>\n

\"\"<\/p>\n

Now Access OLE Import<\/a> will embed the images directly in the table.<\/p>\n

\"\"<\/p>\n

Learn more about Access OLE Import here<\/a>, or download<\/a> a 14-day trial now.\u00a0 Access OLE Import<\/a> can help you update batches of records easily, instead of having to update each record individually via your application.<\/p>\n

See here<\/a> for a more detailed example on how to update embedded OLE Object data.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

Have you ever needed to update the linked file locations in an OLE Object-type field in your database?\u00a0 Access OLE Import can do all that for you and more. Let’s say you have a table with an OLE Object column that contains links to a file.\u00a0 In SQL Image Viewer, you may see the following: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[139],"tags":[140],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1499"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=1499"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1499\/revisions"}],"predecessor-version":[{"id":1522,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/1499\/revisions\/1522"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=1499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=1499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=1499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}