i have a database which is 13000kb that should only be about 3000(by comparing it to similiar dbs).
i did have a lot of images in the tables that i deleted but it doesnt seem to have saved space.
Also is there any way of linking images into a table,to save space. i tried using a bitmap image then linking it to a file but then when i bring it up in a form its just the icon of the file and not the actual image itself.
store the path to the image
place an image control on your form
in the forms on current event place some code which calls an assignment function
in the control (containing the path) place some code which contains a call to the same function. the choice of events is up to you (couild be lost focus, on change etc..)
your assignment function should check that the image exists before assigning it. you can also use the "on error" error trapping to handle the missing file. It may also be 'smart' to either hide the image if file not found, alternatively always insert a blank image prior to trying to assign the new image. (I've often used a blank image which says 'Image not found' as a place holder.
to recover the sapce in your db try tools | database utilities | compact & repair
on error goto imagenotfound
onerror goto 0
'insert any error handler
<myimagecontrol>.visible=false 'if you go down that route remember to set to visible after you have set the image