asked on

OLE Object or Hyperlink Field Type?

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.

SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Dan Van Vleet

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kittenwhisky

ASKER

I feel that lolbox's solution is the best one for my current case (just reference for conversation logs).

I recognise that fyed's solution is the most complete in result and in description, and I will certainly use it in the future. So I gave you some points too.

Thanks for your help!