Hi,
Sorry, I seem to have missed the NOT-part and Access-part completely...
It might be easier to set up a WebService-interface to your AR System,
where you can let an external system extract the attachments.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> I am looking into some possible migrations from different databases (SQL
> 2005) to BMC 7.6.04 (SQL 2005). I can access the external databases (not
> AR SYSTEM) using View Forms. The plans is to build workflow and then
> migrate some of the data.
>
> How can I best solve attachments? I understand that field type 'image' is
> not support by view forms. external databases uses the same field format
> 'image' as AR System. It should be possible to get these attachments by
> direct SQL? Any tips? Any utilities?
> ~
> Terje
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"