Cannot have Memo or OLE Object fields in aggregate argument <statement>. (Error 3115)

[Connie1122]

Hi,

We had an Access app working in previous version. But after convert to 2007 and change the linked table to Oracle, some graph report are not working and get the error

Cannot have Memo or OLE Object fields in aggregate argument <statement>. (Error 3115)

any idea? thanks in advance

[NTC]

It is probably best to rebuild the non working query/chart.

Also; theoretically, a memo or OLE field has no place in an aggregate query. It is possible that Access2003 was more forgiving in this regard. So in the rebuild I would leave them out, at least at the beginning when you are in test mode.

Finally - moves from 03 to 07 (or whatever) some times do surface issues. That's just the way it is with all code & databases. Whether or not the link to Oracle table is related I can not say.

Hope this helps a little.

[Connie1122]

Thanks for your reply. I did find the problem in the query which has the wrong data type. Now this is fixed.

But I get a different error when running a graph report

run-time error "2771"
The bound or unbound object frame you tried to edit doesn't contain an OLE object

and the debug stop at this line

Me![MSGraphRatio].Object.Application.chart.axes(2).minimumscale = CDbl(xmin)

do you have any idea? thanks