Hi!

Of course, it is MUCH better to store files. Either VFP or SQL server have certain hard-time things when working with BLOBS. Specially frustrating VFP's limitation to 2GB for FPT file (storing BLOBS in VFP memo field) or messing with workarounds to get/send data to SQL Server from VFP (see FAQ#7995). Anyway, to organize sequrity to hide certain group of BLOB files from users when using file system, you will require to have as many folders with sequrity settings as you have different sequrity groups.


>Which database is better at storing and retrieving Binary Large Object data.
>
>
>Security issues aside......
>Is it VFP or SQL Server.
>
>Is either of these a good technology for storing this type of data or are the BLOBS better dealt with as independent files in a folder.
>
>All comments gratefully received.