I am new to MS Access. I am designing a new database, one of the tables contains a log of calls made. I'd like to include a field that stores documents used during the call. It could have multiple files. I do not want to actually store the file in the database, I just need to point to it.
File types include MS office files (excel, powerpoint, word,...), pdf files, other word-processing documents, pictures, ...
Multiple files can be attached.
Some files may be used for several calls, hence a quick copy&paste feature would be great.
I am unsure whether to use OLE object type or hyperlink type. Can you recommend one? Or is there an alternative efficient solution for this?
I use MS Access 2003, so the attachment file type available in Access 2007 version cannot be used.