cannot have memo,ole or hyperlink object in aggregate argument

I

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
 
B

Bob Barrows

inungh said:
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.
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top