Solved

OLE Data Retrieval form Access using VB recordset

Posted on 1998-11-19
1
348 Views
Last Modified: 2013-11-25
I have got an Access table of which one field is OLE Data type. I want to retrieve that data using Visual Basic DAO ( Recordset). I want to know what is the data contained in that field recordwise, whether it is a bmp file or excel sheet or word document...like that...
  It will be highly helpful for me if anyoe could give me a help in this matter.

Thanking You in advance..

Regards
Manoj.

Pls reply to the mail id Manoj_mjt@hotmail.com
0
Comment
Question by:sriven3
1 Comment
 
LVL 3

Accepted Solution

by:
tcurtin earned 100 total points
ID: 1968868
Normally, Access will reflect the 'Class' ID of the data. For instance, if it was a bitmap, the field would reflect "bitmap.Image'. Another thought is, you can display the Ole document as a icon on the form. Just select Insert->Object, browse to the file to either link or embed. An option on the lower right of the screen allows you to 'Display as icon'.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

777 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