Hi

I have a database with an MS SQL back end and now have a requirement
to store electronic copies of documents within the database.

I know SQL can store electronic copies of documents as we have another
- quite seperate - off the shelf package that does this.

However, is it possible to do it from an MS Access Front End, and if
so, how?

Thanks

Gary

Gary wrote:

Sounds like some database bloat. Can you store the file to a folder and
store a hyperlink to the file in a table (with a hyperlink field) in
Access? Using HyperlinkPart(), extract and call the link

'creates a hyperlink
a = "TestFile#C:\Test"
? hyperlinkpart(a,1)
TestFile
? hyperlinkpart(a,2)
C:\Test

With the filename, then use the code at
http://www.mvps.org/access/api/api0018.htm to open the file.

On Jan 21, 8:46*am, Salad <o... (AT) vinegar (DOT) com> wrote:

You could use Access as only a front-end, having a server product
(mssql, mysql) storing the documents as blobs.
To reduce 'bloat', you could even compress or encode the files first,
using compress() in your inserts and uncompress() in your selects.

I personally manage a mass document storage app, and I store a UNC
path to each document as well as a searchable text or ocr
representation, using mysql.