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.
The field type you want is a BLOB. I haven't tried using one through access, but theoretically it should work if your ODBC connection has Enable LOBs turned on (on the Oracle tab of the connection configuration).
I will check that out for sure. Funny, there were a bunch of BLOB fileds in the oracle db when I started this but Access choked on them so the DBA changed them all. I wasn't aware of the setting in the ODBC connection so that is very helpful information to have!