Surely one could tap into an Windows event or message to update the database. Shortcuts are now automatically updated when a file is moved, so it is feasible. I'll look into it!
IMO, that would be an advantage over other solutions (like Ultra Recall or myBase).
I could certainly store files in the database, but am relunctant to do it. If someone gives a good reason to do it perhaps...
I share the same point of view : I don't like to store files (different file types) in one database. I've always disliked it, for many reasons.
- One of them is backing up -- while some will advocate that it facilitates backup**, I find that it makes it cumbersome and harder to manage : backing up a 2gb database is not as convenient as backing up a 34kb file.
- Another reason is that most stored files lose some of the features tightly linked to their specific format in the first place (why edit a word document in rtf????).
- Another one is that, usually, not all file types can be stored and managed in a database (so what's the point?? If I'm going to put files in a database I want to be able to put any file I want. Not only *.doc, *.txt, *.rtf, *.pdf., *.jpg and *.bmp).
- Another one is the fear of data corruption. Often, when a database is corrupted, and it happens, chances are you'll loose quite a bit of data.
So... yes, just linking is fine with me. Others might have other opinions on database and storing files in them (J-Mac ?). I'd be glad to hear them!
**"you just have one file to backup", etc. . But I don't care, personally: I have a good backup program.
P.S. : I just tried the new beta : it's looking real good. But I'll either post about it in the SQLNotes Forum or in the other thread focusing on SQLNotes.