OK I think I even passed over this a few times in designer but isn't there a way to hide elements within a form, making them available to some but not to all??

THATS IT !!     I knew I saw something to that effect somewhere... now I just need to play around with adding pictures 

Just some thoughts, no code.......

Don't know if you did this if it would speed up, but its worth putting on the table for some feedback from Mark/Erika.

How about a duplicate of the form with the images.  The "non-image" form without would be the default form normally used. but add a button to see the image.  If button clicked, retreive only that one record in the other form.  A button on the "image" form, could close that form and return to the default "non-image" form.  Even better, what about an "image" form that only has only the image, none of the other fields?  Click on the button to have the image form pop up, close the image, and return to the default form.

Another option vs. an image form is to use @Shell and call up the image in an imager viewer instead.  Should be a separate resizable window.....I like that better,   hmmm.... ???   

Actually, after thinking about this, I think you should submit this as a new  topic.

Mark,

We have a form that is used to view 4 images that are all used on our website. The file sizes are all small (the largest .jpg is under 75kb, usually).

On our 10/100 network without about 4 other 'light' users working, it takes about 1 second to display all 4 images, which is fine but mass updates seems to pretty slow since the forms are waiting for the images to show up.

The real issue is when I try to work on this form from home over my internet connection (broadband at both ends). It may take 10 seconds to display each record.

We've found it VERY convenient to have a text LE just below our Image LE that shows the filename. I think I will place a command button by each image over 10kb that the user can use to display an image in the image box whenever desired. (I guess this is the same as unbinding the image LE that you and others have suggested. That should work well for me during mass updates.)

Thanks for the tips. I'll let you know how it goes!

Steve

I finally got around to trying out the above suggestions to speed up our database. Unfortunately, the server keeps crashing. Here are the details:

I changed the image field (image1) lto a text field and then created an unbound image field called image2.

I put a command button to do the following:
image2=image1

I tested this on our LAN and it works great! Forceredraw() was not needed so I did'nt add it to the program.

I got home and connected to the office server and tried it. Advancing through the records was MUCH faster (THANKS Mark and Bob!), but when I pressed the button to show the image, the server crashes every time and usually gives the message "Runtime Error  R6025 -pure virtual function call.

Any thoughts? Would the command Forceredraw() help?

Thanks,
Steve

Mark,

Since I am still using the original image fields (They are now just a different 'type') I can't imaging any programming would be causing a crash.

(For example, I may have on form exit programming such as: if @isblank(image1) then writeln("Photo is missing")

I'll review my programming tonight when I get home.

Thanks,
Steve

Oh OK. 

I'll wait to hear your results.

Thanks!

Steve

FYI - the form with the issue actually has 2 unbound image fields, one for a thumbnail (3-8 KB) and a detailed image (50-150 KB).

At work we use a 10/100 lan and the 'show image' button works perfectly. And makes mass updates MUCH faster!

At home I connect to the office via broadband at both ends. The bottleneck would be my upload from home at about 200kb. I never have connection problems using sesame from home to connect to office.

I have not used sesame over dialup.

I have noticed that when I press the "show image" button, the unbound image (thumbnail image) field turns white as if its trying to load, but the image does not appear. (Perhaps forceredraw would fix that). I believe the crash does not occur until I press f10 or f9. then the red "working" light flashes repeatedly, then stays red. THis is the point when the server crashes.

Thanks for your help. Let me know if I need to try some other things.

Steve