I am currently setting up a document database, as well as several others for an application that will take in document control, item control, change control, MRP, and a couple of other related applications.
The OLE fields have been around for quite awhile and I have attempted to use them in the past with limited success. What I have in mind is a field to store a barcode that could be used and kept in a document record. It is my thought that an OLE field might be a good place for this. Are there any pros and cons to the usage of an OLE field for this?
Another field that interests me and is new to me is the attachment field. By the description I have a pretty good idea what it does, but can anyone give me some detail on it's usage and reliability?