So I've create a db for my Delica beads. Each color/size has a unique code. I have sample pictures in a folder with my database so I can display the pictures (file paths in db). However, if I move that folder (or share a copy of the db with a friend) what would be an easy way to update the file path? I'm thinking update query, but how to distinguish between path and filename?