Attachment Viewing

[wmc326]

Hi All,

I'm an intern building a database for my companies website and have a (probably simple) question about attachment viewing and editing. I know you can view, edit and add attachments within access itself, but is it necessary to include a button if it were to be exported to a webpage?

I'll include a picture of the database for further clarification.

Thanks in advance!

[June7]

To view in web page, yes need VBA to export the attachment to external location. Then I expect would have to reference it in HTML code.

What are these attachments?

However, editing the file in web page is another matter, don't know how that could be done.

Embedded files in db can quickly use up Access 2GB limit. Why store in table and not just leave as external files?

[isladogs]

Agree with June7
Avoid embedding files as attachments in Access db - it will rapidly grow in size & slow down dramatically well before you hit the 2GB limit at which point it will become unopenable

If you instead have a field with the path to the file, you can open it in one of 2 ways:
a) use code to open the file in the default external application e.g. docx in Word ; pdf in Acrobat or whatever
b) use a web browser control to view the file in Access itself