I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some code online that uses addchunck, but it does not work in MS Access 2003. I can Drag and drop the files into the field if it is in the datasheet mode, but that is real ugly. I will also have to extract the document for viewing by the user. All of the documents are MS Word. Can anyone help with a MS 2003 explanation of the process?
November 11, 2005 10:45 AM
November 14, 2005 1:11 PM