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