Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    63

    Unanswered: Storing and Retrieving Files (.Doc, .PDF)

    I have SQL Server 2005 Express edition with an Access 2007 front-end. I need to store files and allow users to access the files using Access 2007. The users will not be modifying the files; just viewing them.

    I read some forums and some suggest storing the file as a BLOB while others suggest storing the file into a physical location and then have SQL Server keep track of its location. Can someone give me advice on what solution will be most appropriate for my users' needs?

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    SQL Server Express won't support multiple users legally, and from a practical perspective it won't perform very well either.

    Assuming you get an appropriate SQL Edition, the question is just a technical issue.

    Storing the files themselves in the file system and storing the location (such as a UNC name) is easy and efficient for users that are part of your domain. You can simply launch the appropriate application with the file name as an argument, and the app will open as though the user had just double-clicked the file in the WIndows Explorer.

    Storing the file data as a BLOB means that the application needs to be more sophisticated, but it is easier for the user to install and manage. The app needs to retireve and reconstitute the files when the user needs them. The app needs to understand everything about the data and the associated application(s) to ensure the user's experience.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •