Data corrupted and need to fix it

[alexjvp]

I have a Database that is corrupted and need to fix it. I tried the tools in the MSaccess interface and it does not work. How can I recover the information????

 

[Banana]

One way is to create a new blank database, then import everything into it.

 

[alexjvp]

Thanks for your response

One way is to create a new blank database, then import everything into it.

Banana, thanks for your response. I alredy did so, but I can't access the database. I am looking for a way to acces the tables a make a copy of the data. That's all I need. I am a system engineer ans worked with MySQL and used to do progamming in C language (long time ago though), but I could eventually get my hands in something that you may know works. Thanks, and regards.

 

[Banana]

Exactly what do you mean by "can't access the database"?

Is it secured? What happens when you try to open it in Access?

The problem as I see it is that if you can't even import it to another database in native environment, it's going to be very difficult to make anything out of it.

If it's not encrypted, you still can open it with a text editor and sludge through the gibberish and extract the plaintext stored as unicode.

 

[shadow9449]

Banana, thanks for your response. I alredy did so, but I can't access the database. I am looking for a way to acces the tables a make a copy of the data. That's all I need. I am a system engineer ans worked with MySQL and used to do progamming in C language (long time ago though), but I could eventually get my hands in something that you may know works. Thanks, and regards.

One trick I've used successfully in really corrupted databases is to import tables into Excel.

SHADOW

 

[burrcm]

Recovery in 2007 works much better than the earlier versions, so if is an earlier version, try opening with 2007 If successful, save as accdb, then convert back to mdb.

Chris B

 

[alexjvp]

Exactly what do you mean by "can't access the database"?

Is it secured? What happens when you try to open it in Access?

The problem as I see it is that if you can't even import it to another database in native environment, it's going to be very difficult to make anything out of it.

If it's not encrypted, you still can open it with a text editor and sludge through the gibberish and extract the plaintext stored as unicode.

Thanks for trying to help Banana. Here is what happens. Supously, the software was working well until something happens with the energy. So, the next day the database did not open. The database is not encrypted but it is compressed though. I am trying to retrieve the info to an inicial (blank) copy of the database. I wonder what tool could I use to get the information. I tried what microsoft recomends, which is using the reparing tool, opening a blank database and import the tables, but in did not work in either way (I can not retrieve the info, because I get a popup screen telling me that there is an inconsistency in the database and it says something related to the DAO compressing way). This popup screen is always showing in either attempt I try. I also know that there are some companies and people that especialize in recovering the data in this type of issues. In fact, I know the issue happend because of a energy proble or something like it, and I know there must be some way to solve this.

 

[alexjvp]

One trick I've used successfully in really corrupted databases is to import tables into Excel.

SHADOW

Thanks Shadow, I appreciate your response. But we have more than 500.000 records, and it is quite higher than the row limit in MSExcel. Any other idea???

 

[DCrake]

Simple Software Solutions

Do you not make backups? It is a very hard lessen to learn if you do not have a disaster recovery plan, especially with mission critical data.

CodeMaster: