Image Gallery

[kitty77]

Does anyone know an easy way to delete images from the image gallery? I can only delete one at a time by inserting images and the dropdown appears, right hand click and delete image. Looking for a easy way do delete several at a time.

Thanks...

 

[theDBguy]

Hi. You could try using a DELETE query. Let me see if I can find an example.

Edit: Okay, you could try something like this:

DELETE FROM MSysResources WHERE ID In(1,4,6,9)

PS. Make sure you try it out on a copy first and make sure you have a backup copy of your db. If you don't know the IDs you want to delete, you could also try using the image names. Hope that helps...

 

[jdraw]

You may find some info in the Similar Threads at bottom of this page.

 

[isladogs]

Just to add to the DBGuy's answer.
The MSysResources table is an editable system table which is normally hidden. It also contains other info such as themes.
As it uses an attachment field, it is linked to another deep hidden system table which stores the attachment field info.
As a result, the delete query does not always remove items from the image gallery until you restart the app or compact it