[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

OLE Data Retrieval form Access using VB recordset

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

872 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