Db Bloating due to images

[lynxbci]

Hello,
I have a small (8MB) database that we use to monitor vehicle panels. The user enters a panel ID and it calls an image from a folder.

I have the paths stored in a table and use image1.picture = path

However, every time the user is calling a panel to see it, the database is increasing in size, by the size of the image file (300kb). So in 15 minutes the Db has grown from 8MB to 180MB.

Compact and Repair does not resolve this.

How can I stop this please?

Thank you

 

[pr2-eugin]

This is bizarre, are you sure you are not storing the image in the table rather than just showing it when and where required?

 

[lynxbci]

No, I have a folder on the C drive with 100 images and the code is :

Variable fname is called from a table of paths, but in reality this is what is happening

fname = "C:\Automotive\Inspection\PROGRAM\Ferrari_F150A.jpg"
Me.Image0.Picture = fname

And I have the explorer open on a separate screen and each time this line of code runs it increases the DB by the same kb as the file loaded.

I am bemused.....

 

[pr2-eugin]

My question was different and you have answered No, but not really made good sense. Let's try again. Go to the Form design view. Click on the Image0 in the Form, see the Property sheet. Under Data tab, Check what it says under Control Source. If it says anything then it is bound to a field in the table. If it is not then there is something other issue we need to look at, and a Stripped copy of your DB might be needed.

 

[Simon_MT]

That does quite unusual. There is no chance that the Imagecontrol has a control source attached a data table? Or the Proerty Picture Type set to Embedded.

Secondly which Image control are you using the Bound Image Frame control or the Image control?

You should set just in the Picture Property Image format to native formats.

I have dealt with 20,000 images I haven't seen this before. For obvious reason storing images would have exceeded the size limitation and I have always referentially rendered the images.

Simon

 

[lynxbci]

Updated

I tried removing a pictre that was added at design, which did not solve it.

However, I embedded the image control and this seems to have solved it. I loaded up 50 images and no increase in database size so far.

Thanks for all your help, much appreciated