Hi Frank, Hi Brian,
As Brian says, I would always go with 'linkfile' rather that 'storefile' otherwise you'll find that your database can quickly get pretty big.
Use 'copyto' in conjunction with 'linkfile' and you can set up a hierarchy of folders within your application where you want to store files that is discrete from your sqlite.db.
To answer your question about opening, editing and saving files, there are two basic approaches.
The first approach is simply to shell out to MSWord, Excel etc and do your work directly in the application. This is pretty easy.
The second approach is to pull the file into MVD, edit it and then save it back out which isn't quite as straightforward, but can be done.
My preference is for the first option (and not just because it's simple - LOL!) but because you have a consistent approach no matter what type of file you are referencing (for example, in the attached example, there are .txt, .rtf, .pdf, .png, .jpg files - but it could be any file type) and it's exactly the same in all instances - click on the file name and it opens using its default program.
In the attachment, files can be accessed either through the tablegrid (Form1) by clicking in the appropriate cell or accessed on Form2 by clicking in the dbfile field on the file name. There are many ways to do it but in this example, I use 3 folders within the application to store application forms, photos and references.
Hopefully it might give you some ideas how to move forward.
Derek.