This discussion is archived
2 Replies Latest reply: Oct 4, 2012 5:31 AM by 965531 RSS

Microsoft Access Attachment field and Oracle

965531 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points