Hi! I'm working in a vb6 app with SQL Server 2008. This app is a kind of CRM, so we have a entity for the customer and we would like to attach some files to each customer (ex: docx, xlsx, jpeg, and so on). The app will be accesed by several users and this files has to be available for all of the users. The first option I was thinking was storing the files directly in the database SQL in a byte field, but for obvious reasons I'm not convinced. Another option was to simply store the path of the file, but in this case the file may not be available for all users.
Could you give me your opinion about the best way to do this? I'll be very grateful!
Tks in advance and excuse my rusty english!
Cristian