Check out www.officerecovery.com. They bill themselves as "the web source of data recovery software for corrupted Microsoft Office files." Each software tool comes in a free downloadable demo version and a commercial version (the latter presumably with more capabilities). I've
never used any of their software myself, but you might as well give it a try, the price is right .
Diana Bouchard
********************************************************************
Diana C. Bouchard
Pulp and Paper Research Institute of Canada (Paprican)
Process Control Group
570 St Johns Boulevard
Pointe Claire Quebec H9R 3J9 Canada
phone: (514) 630 4100 x2376 fax: (514) 630 4120
email: [email protected]
*******************************************************************
I more than 100% agree with you and would like to see what Microsoft uses for its database? I am ready to bet it will not be Access. Access was not designed to be used in real time environment.
We did use it in one project for real time application but in the next one opted for alternative databases due to corruption issues like this. In fact, it was not even used for data gathering but for just engineering, changes both offline and online.
If you are using *.mdb DB you will get used to that. It happens on a very regular basis. Have fun. ;-)
The only way of using mdb's savely is to backup them as often as you can! If the DB is so corrupted that it is not recognised. It is very likly that you can not use it any more anyway.
Sorry i could not help you but its better not to use Access for serious things. It more like a toy than a tool.