How to extract images in Access stored as OLE objects?

[Hosacans]

HI All,

the database that i am using is getting to big due to the ole objects. I searched in the Access VBA forum and found that there's a way to display images on reports using a link. I am going to try converting my database to that but first i want to extract all the images i've stored on my base table. since i dont have any back up of it..

any ideas?

Thanks
Hosacans

 

[RuralGuy]

You will find this link helpful:

http://www.lebans.com/oletodisk.htm

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[Hosacans]

Thanks this is a great tool!!

-Hosacans

 

[RuralGuy]

Stephan has several so look around his site. You are welcome.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[Hap007]

Dear Hosacans,

It is true that placing OLE objects in a database will cause DB bloat.

Yet, I am always worried that if I store the OLE files on disk/network and use a link, that the files may get deleted or re-located and the report or whatever, will fail or not work as planned.

Usually, the images are only needed occasionally, for reports and the like.

Another suggestion might be to create a separate database, and a table in this database to hold the OLE objects. This table also should have a key.

Then, link that table to your program.
In the table that you originally stored the OLE object, just store the key.

Now you have the best of both worlds.

Your primary database will not suffer bloat from the OLE objects, yet the objects are still stored in one place(DB).

I have used this and it works great.

Just my 2 cents,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121