with DAO 3.5, how to open in read-only mode an already opened Access file ?
Posted on 2006-03-22
i use MFC and DAO 3.5 to open Access 2000 files; if the file is already opened by another user in exclusive mode, i get (and intercept) an exception, then i retry to open but this time in read-only mode (so that i can at least read some infos in the file) :
m_pDatabase->Open(strPath, FALSE /* bExclusive*/, TRUE /* bReadOnly*/);
--> i get again the same exception saying that the file is already opened in exclusive mode (DAO error code = 3045);
yet that method worked with dao 3.0 and access 97 databases.
So, how can i , with dao 3.5, open a file in read-only mode even if it's already opened in exclusive mode ?