Hi Art,
there are a couple of key phrases you use, "can contain images or scanned documents" and "The images our stored on a different server." By "Scanned Documents" you mean PDFs, right, and not TIFFs? By "a different server" you mean that the files are stored as files? No matter whether they are images or scanned documents?
If you were only talking about pictures i would have recommended an alterative method to the one John does and stored the binary data for files in a memo (now varbinary) field on the SQL Server and used routines from www.lebans.com in order to display those images.
As you are talking about mixed file types you need to handle multiple file types. Have you thought about "cheating" and using a local ACCDB temporary table? When you come across a record which has an attachment you load the attachment into the temporary table attachment field and let Access and your code handle it just as it used to?
P.S. in some circumstances I might have pointed you to the use of a FILESTREAM in SQL Server for storing the image and document files http://msdn.microsoft.com/library/hh461480 but this isn't going to solve your question in and of itself, just provide an alternative storage.
Yours,
Andrew
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar