Extract OLE object from table to a folder

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Extract OLE object from table to a folder

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 9th, 2006, 11:17 PM

ysiline

Authorized User

Join Date: Dec 2003

Posts: 25

Thanks: 0

Thanked 0 Times in 0 Posts

Extract OLE object from table to a folder

Hi,

Could anyone help me on extracting OLE object store in MS ACCESS table back into folder?

I stored "*.wav" file in OLE field by below code:

      [OLEPath] = MyFolder & "\" & MyFile
      [OLEFile].Class = [OLEClass]
      [OLEFile].OLETypeAllowed = acOLEEmbedded
      [OLEFile].SourceDoc = [OLEPath]
      [OLEFile].Action = acOLECreateEmbed
      MyFile = Dir
      DoCmd.RunCommand acCmdRecordsGoToNew

Regard,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
embeding an OLE object	ricespn	Beginning VB 6	0	August 17th, 2007 12:47 AM
ole object insertion	vinodkselpy	Crystal Reports	0	March 1st, 2007 07:31 AM
OLE object in ASP	MDrumm	BOOK: Beginning ASP 3.0	3	June 18th, 2005 10:48 AM
OLE Object Type?	[email protected]	Access VBA	1	October 20th, 2004 02:16 PM
OLE object in table and Form control	bleitner	Access	3	November 21st, 2003 01:24 PM