error trying to open my database 'Unrecongized database format'
-
I'm using an access database with VC6. My program has been working well until now. I get the message 'Unrecognized database format' and then the path. I presume that I have a corrupt database and I have tried to repair it but I just get the same message. Does anybody have any suggest how I can repair it, view or extract the data. I did have the same problem about a month ago, but I was able to repair it. Can anybody suggest why this is happening == I used CDaoDatabase to extract tables list in .mdb file Plz Help . It is very Urgent:confused: Praveen :C
-
I'm using an access database with VC6. My program has been working well until now. I get the message 'Unrecognized database format' and then the path. I presume that I have a corrupt database and I have tried to repair it but I just get the same message. Does anybody have any suggest how I can repair it, view or extract the data. I did have the same problem about a month ago, but I was able to repair it. Can anybody suggest why this is happening == I used CDaoDatabase to extract tables list in .mdb file Plz Help . It is very Urgent:confused: Praveen :C
parims wrote: but I was able to repair it. So you where able to successfully repair the db right? Did you follow up with a compact db? Question do you have blob (i.e. “memo”, “OLE Object”) columns? Those are the biggest reason I have seen a db get corrupted. If possible change the design to eliminate those types of columns or create your own row locking mechanism so people can’t access the same row at the same time.
DEBUGGING : Removing the needles from the haystack.
-
I'm using an access database with VC6. My program has been working well until now. I get the message 'Unrecognized database format' and then the path. I presume that I have a corrupt database and I have tried to repair it but I just get the same message. Does anybody have any suggest how I can repair it, view or extract the data. I did have the same problem about a month ago, but I was able to repair it. Can anybody suggest why this is happening == I used CDaoDatabase to extract tables list in .mdb file Plz Help . It is very Urgent:confused: Praveen :C
I think you problem is that you are using ACCESS 2000 or newer (that means Jet Engine 4.x). Then you need to trigger the use of DAO 3.6 instead of DAO 3.5 which is the default of the MFC DAO classes in VS6. If you use MFC in a shared DLL, you can easily resolve this problem by putting the line: AfxGetModuleState()->m_dwVersion = 0x0601; into your code before you call AfxDaoInit(). Hope this helps MS
-
I think you problem is that you are using ACCESS 2000 or newer (that means Jet Engine 4.x). Then you need to trigger the use of DAO 3.6 instead of DAO 3.5 which is the default of the MFC DAO classes in VS6. If you use MFC in a shared DLL, you can easily resolve this problem by putting the line: AfxGetModuleState()->m_dwVersion = 0x0601; into your code before you call AfxDaoInit(). Hope this helps MS