artful at rogers.com
artful at rogers.com
Thu Dec 21 15:30:46 CST 2006
I am not sure of the mechanics, but I feel obligated to question the approach. To what advantage is it to store the images as binary objects in a column? If you have a large number of images, you may have a point (given the built-in restrictions on number of files in a directory), but that aside, why bother? Why not store the path to the images instead? Then all you are dealing with is a varchar(100) or so string and you don't encumber the database at all. You can hand off the path string to whatever front end is of interest and the front end can accept the path and load the image. IMO, the same thing applies to Word documents or any other sort of binary storage. I just don't see the value of storing a file as a binary object in a row-column. Arthur ----- Original Message ---- From: Steve Zayko <szayko at secor.com> To: dba-sqlserver at databaseadvisors.com Sent: Thursday, December 21, 2006 3:45:36 PM 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