[dba-SQLServer] Upload documents with MSAccess FE

Would they not have write access to the same directory as the backend mdb
It is required to write and create the accompanying .ldb file

Steve Zayko wrote:

>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.  
> 
>-Z  
>
>________________________________
>
>From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Jim Lawrence
>Sent: Thu 12/21/2006 01:55 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: Re: [dba-SQLServer] Upload documents with MSAccess FE
>
>
>
>Hi Stephen:
>
>My recommendation is to just store a pointer to the PDF files and store
>these objects in their own separate directory somewhere on the server. This
>is much safer, less complex and faster.
>
>Just a recommendation.
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Steve Zayko
>Sent: Thursday, December 21, 2006 12:46 PM
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Upload documents with MSAccess FE
>
>I am trying to develop a system where Adobe pdf documents are stored in
>a SQL server database.  The method I am using to "store" the files is an
>MSAccess front end.  I have an unbound form with an Object Frame and a
>few other text boxes for extraneous information.  I try to place the pdf
>document in the object frame with the menu command Insert/Object and
>then run an SQL script to append the object (and other data fields) to
>the destination table in the SQL database. 
>
>The trouble I am having is that the field in the destination table is
>"Image(16)".  Every object I append to the table in the method described
>above fills the entire memory space allotted for that field.  Thus a
>20Kb pdf file will become a 5+ Mb object once in the field. 
>
>I don't need to know the mechanics of why this is happening.  I just was
>wondering if there were others who have experienced this (or similar)
>issue and what can I do to fix it.
>
>Thanks in advance for you assistance.
>
>Should I cross post this to AccessD list?
>
>Stephen R. Zayko PE
>SECOR International Inc
>2321 Club Meridian Drive Ste E
>Okemos, MI 48864
>
>(517) 349-9499 ext 224
>(517) 204-5136 (c)
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada