Hello Everyone and thanks for your help in advance. I am developing a document storage application for an intranet that will store various Word, Excel, and PDF documents. Most of the examples I see utilize SQL Server and an image field rather than the FileSystem Object to store documents. My concern with this method is that some of the documents may be several hundred pages (not exactly sure of the actual file size yet, but they must be fairly large). My question is, where does the use of SQL Server become impractical for this type of application? Any insight would be greatly appreciated. Thanks.

  - mainly because they're there to illustrate the principle, not because it makes real-life sense. Generally, if you're looking at using BLOBs in your db, you'd be better off using the File System as you mentioned. It's much easier in the db to update a path to a file than to update the actual BLOB.

Check Jeff Mason's reply to post 'how to insert image in sql 2000' in this forum.

HTH
Chris



There are two secrets to success in this world:
1. Never tell everything you know