Adding Logo to Forms

[tucker61]

Quick question, On my forms i have a jpg of our company logo embeded into the 20 or so forms. I decided to change this, so I linked the picture from our network to the form and the size of my database increased from 12mb to 300 mb. Cant see why this would happen, as i would imagine a linked picture is smaller than a embeded picture.

Does this sound correct ? or should i just leave as embeded ?

Regards
Gareth

 

[isladogs]

A linked file should be better but perhaps your file type is the issue.
Lossy file types like JPG do not work well with Access.
Better to use BMP or similar.

Also, did you remember to compact the db after making the change?

 

[tucker61]

A linked file should be better but perhaps your file type is the issue.
Lossy file types like JPG do not work well with Access.
Better to use BMP or similar.

Also, did you remember to compact the db after making the change?

Yes.. compacted and went down to 274.

It was a jpg, so i will try again with .bmp.

Thanks

Sent from my SM-G950F using Tapatalk

 

[isladogs]

12 to 274mb is not good! Perhaps you embedded it somewhere as well?

 

[tucker61]

Looking at the Jpg, Bmp files the jpg is 184kb, and the bmp is 1500kb. so both files are relatively small and should not increase the size of the database like that.

I will have another go on Monday and try and find out what i am doing wrong.

 

[isladogs]

As BMP files are not a lossy format, they are normally bigger than the equivalent JPG.

Even so, they do not cause as much Access bloat in my experience.

I think both files are far larger than they need to be.
Suggest you shrink the file dimensions (pixels) to the size you need for your forms and note the change in file size.