Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 3114 cannot include memo, OLE ... when you select unique ...

Status
Not open for further replies.

siqual

Programmer
Aug 3, 2001
20
0
0
US
I am running into a problem on at least one machine. I have a VB application that was developed on one server and runs fine. Created an installation package and installed it on another server. The application generates the following error with queries that contain memo fields:
Error 3114 Cannot include memo, OLE, or ... when you select unique values.
(Note: The queries do not contain a DISTINCT clause.)

I have not been able to find anything in the microsoft KB, but I have seen references to this problem at several WEB sites. Any one else run into this and what work around(s) have you found. My guess is there is one or more dll's that are not current, but which one(s). Dan Grogan
dan@siqual.com

"Absit prudentia nil rei publicae profitur."
Without common sense you ain't gonna have nothing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top