attachments

[slimjen]

Hi All. Using 2010; I have a task database with a field for attachments. I think
it's fairly new with 2010. I know how to attach an attachment such as a word doc
that may be on my desktop. But how do I get the update in the database if I


change the document on my desktop or from anywhere else? It doesn't change
unless I update the doc(attachment) in the database. I would like some users to
not have to open the database if they want to change the doc and it be changed
in the attachment also. Thanks

[June7]

Another reason not to embed files in database. I think the document in table is a copy, not a dynamic link. Edits in either would not be reflected in the other. You can test that and let me know if I am wrong.

[slimjen]

Another reason not to embed files in database. I think the document in table is a copy, not a dynamic link. Edits in either would not be reflected in the other. You can test that and let me know if I am wrong.

You are correct. So; use a dynamic link? Thanks

[Rawb]

The preferred way would be to store the document as a file somewhere on the network. Then, instead of storing the attachment in the database, you just store a the path to the document (generally as a UNC path or web path).

That way you don't have to worry about two things:

• Artificially bloating the database file (since you're not storing a bunch of extra files in the database itself).
• Users without access to the database can still be given access to the files when needed.

[June7]

Agree with Rawb.

As far as know, the only way Access and Word can 'link' is with mail merge.