2 Replies Latest reply: Oct 4, 2012 7:31 AM by 965531 RSS

    Microsoft Access Attachment field and Oracle

    965531
      I'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.

      Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.

      Any help would be much appreciated.

      Thanks!