?
Solved

OLE Data Retrieval form Access using VB recordset

Posted on 1998-11-19
1
Medium Priority
?
376 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 200 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…

752 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