Using MDB database with OLEDB/ATL/MFC (from SQL Server)

[Gian]

I'm programming a little server application in MFC 7.1 + OLEDB that read from a database. I'm using a SQL Server DB (extactly the MSDE version) and all works good, but now i need to store the data in an Access 2000 file, so i've changed the connection parameters like this: CDBPropSet dbinit(DBPROPSET_DBINIT); HRESULT hr; dbinit.AddProperty(DBPROP_AUTH_USERID, OLESTR("Admin")); dbinit.AddProperty(DBPROP_AUTH_PASSWORD, OLESTR("")); dbinit.AddProperty(DBPROP_INIT_DATASOURCE, OLESTR("C:\\Gestu.mdb")); dbinit.AddProperty(DBPROP_INIT_MODE, (long)DB_MODE_READWRITE/*(long)16*/); dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)DBPROMPT_NOPROMPT/*(short)4*/); dbinit.AddProperty(DBPROP_INIT_PROVIDERSTRING, OLESTR("")); dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033); hr = m_DataSource.Open(_T("Microsoft.Jet.OLEDB.4.0"), &dbinit); if (FAILED(hr)) return false; hr = m_session.Open(m_DataSource); if (FAILED(hr)) return false; return true; } the program logins correctly. but when i try to execute a SELECT statement or other accessor operations and execute them it have an error DB_E_ERRORSINCOMMAND. a sample operation is: CCommand DynamicAccessor; CDBPropSet propset(DBPROPSET_ROWSET); propset.AddProperty(DBPROP_CANFETCHBACKWARDS, true); propset.AddProperty(DBPROP_IRowsetScroll, true); propset.AddProperty(DBPROP_IRowsetChange, true); propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE); DBROWCOUNT rows; CString sql; sql.Format("SELECT * FROM Users WHERE nickname = '%s';", strNickname); HRESULT hr; hr = DynamicAccessor.Open(m_session, sql, &propset, &rows); if (FAILED(hr)) return false; The same code here works perfectly with the SQL Server connection. Is there some parameters to modify? Thanks