Linked Pictures In Database

INFOS

Registered User.
Local time
Today, 10:10
Joined
Jan 15, 2005
Messages
55
What is wrong with this linked pictures in my database?
I have made OLE field in a table and I want to insert pictures in that
field with option "linked". But pictures are not exactly linked. First, they take
a lot of space in a database, almost as inserted pictures (If inserted picture takes 30Mb than linked picture takes 20Mb). I thought it is only going to save a link (target location) to a file. Also, when I insert link to a picture ina OLE field and delete this picture in windows - I can still see this picture on a form in my application. So, is it linked or inserted (only difference is that I can't edit linked picture if it's deleted in windows but I can see picture in a form).
How can I insert only link to a picture in my database so I can see pictures in forms and reports and pictures stays only in windows and takes a minimum space in my database (only for a target informations)???
Thanks!
 
The good news is that it is possible to do exactly what you are wanting to do.

Your best bet is to download one of the samples database given in that particular section of this forum. Oldsoftboss has put together one in 2000 and one in 97 and by studying these you should be able to adapt them accordingly for your application.

Try the below link...

http://www.access-programmers.co.uk/forums/showthread.php?t=62251&highlight=Image
 

Users who are viewing this thread

Back
Top Bottom