Hi.

I try to open .mdb file (MS-ACCESS 2000) with CDaoDatabase object and it fails all the time, here is my code:

CDaoDatabase m_DbConnection;
m_DbConnection.Open(NULL , FALSE, FALSE, "ODBC;DSN=myDB");

I get an error, something about SAMI.

If I convert my .mdb to older version OF MS-ACCESS then I can open it with this
code:

CDaoDatabase m_DbConnection;
m_DbConnection.Open("c:\\myDB.mdb");

but trying to open it with ODBC it fails...any idea how can I overcome this problem??

Thanks.