Solved

OLE Data Retrieval form Access using VB recordset

Posted on 1998-11-19
1
370 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

717 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