Can Access store/link to entire documents?

[Josh]

Is it possible to store entire documents, such as a
resume created in Word, in Access? I am trying to add a
feature to our corporate intranet that will allow
employees to browse resumes and writing samples by
position applied for and want to avoid having to strip
out resume data and manually input it into our Access
DB. Instead, I'd like to simply have our Web App Server
query Access and pull up the ENTIRE document. Can this
be done? How?

 

[Tim Ferguson]

Is it possible to store entire documents, such as a
resume created in Word, in Access?

The OLE field can do this, but it's not recommended. It introduces HUGE
bloat -- several megabytes per record -- into the mdb.

Instead, I'd like to simply have our Web App Server
query Access and pull up the ENTIRE document. Can this
be done? How?

Yes. Store the filename and path to the original document, and either get
the web server to find the file and send that, or send the link to the
browser and let it fetch it itself.

HTH


Tim F