title: Attach file in MS Access using the path in the same record
body: <p>I have some experience in MS Access, but can't seem to find vba that attaches the file to the record. I only have about 2,000 records (no more since it's a data entry project) so MS Access db size won't be an issue.  Each record has the full path in a "path" field, but I can't figure out how to use vba to attach the file in a new "attachment" field.</p>
  
  <p>Everything I've seen so far is about the user attaching a file or creating a path - not actually using the vba to attach the file (given that I already have the path).</p>
  
  <p>Any help would be much appreciated!</p>