Accessing Attachments from a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database where each record tracks information about a
Request for Quote. I need the ability to allow the user to enter the name of
the attachment (including the location of the file, if necessary), and then
be able to open up that attachment from the same form. I want to store the
attachments, i.e. PDFs, Excel spreadsheets, on a shared drive so that anyone
looking at the RFQ can also look at the attachments.

I see in Access how to put an attachment into a form, but as far as I can
tell, the file name and location are already known and coded into the form as
a linked object. I want to be able to enter the attachment name, and then
link to it as necessary.

Please help!

Thanks,

Dianne
 
I developed a personnel database some time ago that linked to remote,
confidential Word documents that were read/write protected, allowing anyone
with access to the database to open the files without having to enter the
password, but anyone 'finding' the document couldn't open it unless they had
the password.

Apart from the security bit, if this is the sort of thing you want to do,
give me a day or so to dig it out and I'll get back to you.

Pete
 
Back
Top