Where are attached files stored?

[Delta223]

Just curious, are attached files actually stored within the database? Or does access create some kind of link to them so conserve space?


If the former, is it possible to hyperlink a local file?

[ajetrumpet]

it is not a link. you can tell that simply by looking at the size of the file with and without attachments.

the field makes use of the OLE server, which I think is a combination of different technologies. I'm no expert tough.

what do you mean by ''hyperlink a local file''?? are you talking about providing a ''clickie'' address so someone can open and modify the file immedately??

[Delta223]

Yes, that is what I meant. I called it a hyperlink because in Onenote, a "clickie" to a local file looks just like a web hyperlink

[ajetrumpet]

Yes, that is what I meant. I called it a hyperlink because in Onenote, a "clickie" to a local file looks just like a web hyperlink

if you want a clickie, use the hyperlink field. it's still there in version 2010, right? if it's not, use:

followhyperlink "local address"

in code on a click event