[dba-SQLServer] Upload documents with MSAccess FE

Steve Zayko szayko at secor.com
Fri Dec 22 12:24:25 CST 2006


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)

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list