Very Computer

 sprintf(sqlQuery,"SELECT DISTINCTROW [Artist ID] FROM [WCAZ_MasterList]
WHERE ((([Artist ID]) In
                             (SELECT [Artist ID] FROM [WCAZ_MasterList] As
Tmp GROUP BY [Artist ID],[Song Title]
                             HAVING Count(*)>1  And [Song Title] =
[WCAZ_MasterList].[Song Title])))");
 if(CRecordset::IsOpen())
    CRecordset::Close();
 CRecordset::Open(AFX_DB_USE_DEFAULT_TYPE,sqlQuery,CRecordset::none);

Thanks in advance,

Jim Casazza
CAZ Media
http://www.cazmedia.com/mmi - the coolest music on the net

first I must say, that my english is very bad. Acctually I try learn ist  and so
I hope that you can understand me. (a little bit??? please! ;-)) )

Sometime I have the same problem with Recordset::Open(). It happen when I use
ID's in my query. Try it with following code for the query.

// change the ID in a character "umwand"
// without this, the Open statement is incorrectly
sprintf(umwand,"%d",p_RecGesamt->m_ID);

// Now, you can set the query call for Recordset::Open()
// p_RecTeil is my Recordset
CString  strSQL = p_RecTeil->GetDefaultSQL() +
      "WHERE [ID] = " + umwand +
      "And [Teilprojekt] = '" + m_TeilProjekt + "'";

// And now, you ca open the Recordset with Open
// Use the arguments AFX_DB ... and strSQL, because strSQL is the query call
ok1 = p_RecTeil->Open(AFX_DB_USE_DEFAULT_TYPE, strSQL);
 if (ok1) ..... // ok :-)

Cornelia