I am trying to figure out the best way to read an OLE Object in MS Access (photo) into coldfusion and then create a new record containing the photo. I have no choice about the field type or of using MS Access.

Can anyone offer a suggestion as to what path I should take?

Thanks

Not sure I follow. Why do you need to pull the object into CF? You can just copy it from one table to another in a query.

ie
INSERT INTO Table2 ( OleObjectColumn)
SELECT OleObjectColumn FROM Table1

Though I'm sure you already know MS Access and storing images is not a great option ... ;)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.