cannot have memo,ole or hyperlink object in aggregate argument

[inungh]

I have an application using SQL Server as backend and some of users
use Winodws XP and some using Windows 7.

My query works on Windows XP machine, but Windows 7 get error message

"cannot have memo,ole or hyperlink object in aggregate argument "

Any possiibility that Windows XP works but Windows 7 get above error
message?


Your help is great appreciated,


iccsi

 

[Bob Barrows]

I have an application using SQL Server as backend and some of users
use Winodws XP and some using Windows 7.

My query works on Windows XP machine, but Windows 7 get error message

"cannot have memo,ole or hyperlink object in aggregate argument "

Any possiibility that Windows XP works but Windows 7 get above error
message?

Not really. If there is indeed a "memo,ole or hyperlink" column being
aggregated by your query, it should fail regardless of the Windows platform
the query is being executed from.
I would more suspect different versions of Access on each client, and one
version is recognizing one of the columns in your query either correctly or
incorrectly as the case may be.
Your first step is to identify the column that is causing the error.

 

[inungh]

Not really. If there is indeed a "memo,ole or hyperlink" column being
aggregated by your query, it should fail regardless of the Windows platform
the query is being executed from.
I would more suspect different versions of Access on each client, and one
version is recognizing one of the columns in your query either correctly or
incorrectly as the case may be.
Your first step is to identify the column that is causing the error.

Thanks for helping,
Yes, it is what I thought.
All my users use same MS Access and only Windows 7 users get error
message.
I just change my stored procedures to return zero instead of null
value then Windows 7 machines work.
it seems that Windows 7 and Windows XP have different way to read null
value.


Thanks again for helping,


iccsi