Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Dealing with images in Access 2000 continuous forms


Message #1 by shiang@s... on Sun, 9 Dec 2001 23:21:08
Dear All,

I am currently developing a database system with Access 2000 and wonder if 

any one could help me with this issue. Basically the system involves 

records with images (smaller image or Thumbnail) which need to be shown on 

a continuous form and a bigger image with the original size will be loaded 

from another application (IE in this case) by clicking the smaller image. 

At the moment these smaller images are stored as linked objects in an OLE 

Object field and displayed in the form using Bound Object Frame control. 

The links (file path) to bigger images, on the other hand, are stored as 

text, which can be loaded using shell function when the smaller image is 

clicked. However, this implementation is not ideal since Access cannot 

cope with too many images and it's impossible to upsize to SQL Server with 

those OLE linked objects when the database is getting too large. I am 

looking for a way (or any ActiveX Control) which can be bound to a text 

field containing path to images and loads correct images accordingly when 

the path exists in a continuous form. I have tried Unbound Object Frame 

control, Image control and Web Browser control and none of them did this 

trick in a continuous form. Any tips will be greatly appreciated. Thank 

you for your help.



Shiang-Lung Dung

  Return to Index