OLE / Image Field

J

Justin

I have an OLE Image field on a form. Rather than openning the file, I want
to save the file to the local drive and then open. Thanks in adbance.
 
O

Olduke

Justin said:
I have an OLE Image field on a form. Rather than openning the file, I want
to save the file to the local drive and then open. Thanks in adbance.

Justin:
I assume you are working on a network database.
One of the options you have with an OLE object is to embed or link.
If you choose to embed you are effectivly making a copy of somthing that is
already on your computer or server. The size of you database grows very
quickly with a resultant reduction in speed.
If you link, you are just creating a link to the object that is already on
your computer or server.
Why not just put a link to wherever the object is already.
 
S

Stephen Lebans

If you select "link" and do not specify "Icon only" then you will still
experience database bloating as an uncompressed full size Bitmap fo the
Image will be stored.

If the OP no longer has the original file(s) there are tools on my site to
extract object embedded within an OLE field.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top