Linked Photos Problem

[GPM4663]

I've just set up a new database for personnel and have linked .jpg photos of each person to an unbound image control in the input form. I only have about four photos in it at the moment but the file size of the .mdb has already increased by 3 MB. I know that this can happen if the photos are embedded but they are definately linked. I've done this before without any problems and I don't understand why it's causing me problems now. The photos are saved as the persons name so I'm using the following code on the Form_Current event

Me.PhotoFrame.Picture = "\\UPUD\Data\Photos\" & me.firstName & " " & me.surname & ".jpg"

The picture is no bigger than a thumbnail and sits on the form header. If anyone has any suggestions what I've overlooked this time round I'd really appreciate it.

Many thanks in advance

 

[Frink]

Hallo,

Is it still much bigger than before after you've compacted it?

Alternatively, why not store the path to the image as a string field, rather than an actual image and get the image on the required forms?

- Frink

 

[GPM4663]

Hi Frink,
The .mdb has grown from 800kb to just over 3MB and that is with compacting it. I'm not actually storing the image I'm just redirecting the .picture property to go and find that persons image. I have tried what you suggesting by storing the filepath but unfortunately it has made no difference. Any other ideas?

Yours Hopingly,

G.P.M.

 

[Frink]

Hallo,

So all you've done is added the line:

Me.PhotoFrame.Picture = "\\UPUD\Data\Photos\" & me.firstName & " " & me.surname & ".jpg"

to a form module and the mdb has grown by 3Meg?

- Frink

 

[GPM4663]

Hi Frink,
Yep thats fairly much it, hence I'm so confused. Like I said I have done this before and have another mdb which is linked to over 100 photos and its size is still less than 1 Meg! I only have 4 active photos in this DB and its acting as though I've embedded these photos even though everything I look at tells me they are actually linked. Its a case of "Is there something strange going on in the background?". I may have somehow corrupted the mdb but I have no idea how or why?

Thanks for your comments so far,

G.P.M.

 

[Frink]

Hallo,

I'm afraid that's all beyond me. It makes no sense.
I bet removing the line doesn't make the DB shrink to what it was before though.

- Frink

 

[GPM4663]

Hi Frink,
Just tried that and deleting the entire image control and you're right it hasn't reduced any. I think it's time to import all the objects into a new database because obviously this problem extends beyond linking images even though that's when all the problems originated. I just wanted to check that I hadn't done something blatently stupid when setting this up!

Frink, thanks a lot for all your time I really appreciate it.

G.P.M.