[dba-SQLServer] Upload documents with MSAccess FE

Robert L. Stewart rl_stewart at highstream.net
Wed Dec 27 09:17:10 CST 2006

The reason this is occurring is that Access also stores the program 
that opens the file.
You need to use a VB/c# program to store the file instead of Access. 
then you will get only the file stored as a binary.

The overhead with Access is why everyone says not to store the file 
inside of the database.  But, it is limited to an Access 
thing.  Using a different program to load the file will keep the 
bloat from happening.


At 04:11 PM 12/22/2006, you wrote:
>Date: Fri, 22 Dec 2006 10:24:25 -0800
>From: "Steve Zayko" <szayko at secor.com>
>Subject: Re: [dba-SQLServer] Upload documents with MSAccess FE
>To: <dba-sqlserver at databaseadvisors.com>
>         <10B9AE4E39C0DD4BB317CC8A0F0AA4010AF63E at exch100a.secor.com>
>Content-Type: text/plain; charset="iso-8859-1"
>That was the first option that I explored.  However, there is not a 
>common area that all users of the system have write access to.  The 
>system acts like a web-based deployment over a large "closed pipe" 
>network.  Thus storing the files in the database is used.  I know it 
>sounds inefficient.  But this is how the decision makers want it to work.

More information about the dba-SQLServer mailing list