Special queries

[DW]

I'm trying to achieve something I'm not quite sure can be done.

I am working on part of my db which is a form with three fields.

[Ref1]-number
[Ref2]-number
[OlePic]-OleObject.

As you know, pictures bloat a db out of proportion, so here's what I've done to work around this.

Created a form which shows an image relative to the two number fields.
Using a common dialog, I can point to a folder any where on the network & insert it into a linked table.

The forms control source is a query designed around the linked table.

I'm thinking, if I can use a query to pull the images from the server on opening the form, into a local table, and then push them back to the server when the form closes, this will increase the speed of opening the pics.

By this the db doesn't bloat.

Can this be done on open & close of the form.

Dave

 

[mstorer]

I am working on a project that could use the identical help. However, instead of pictures, I am looking to open a MS Word document. Perhaps someone can kill two birds with one stone.

DW - Am I correct in assuming you have inserted a hyperlink (common dialog) to the network directory in place of the actual OLEObject?