Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-04 : 08:48:41
|
| Mark writes "I have developed a network app that uses a SQL database (running on a Server) with a VB user interface (Running on Client PCs). I’m wanting to build a secure document library on the server that users would be able to access through the app from a Client PC. I am aware that the general rule of thumb is not to store these files as BLOBS directly in the database but to simply store a directory path. This makes sense to avoid database bloat, however, if the folder sits on the server, the only way I can get VB to read and write files to this folder from the Client machine is to share this folder on the network, but this leads to all kinds sharing and security issues. Is there any way I can save these files to the secure folder on the Server via a temporary SQL table and visa versa?" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-04 : 14:28:34
|
| We use a document management system called InVu that has a "secure" folder on the fileserver for documents. Not sure how it does it, but it might bare investigation. The database just holds keywords / document path / Parties associated with each document etc.http://www.invu.net/Kristen |
 |
|
|
|
|
|
Tranfering files through SQL