CORRUPT BACKEND DATABASE

[netrusher]

I have a database with backend tables. I came back to work today and somehow the main table in the backend has been corrupted. I tried to repair the table in the Backend and I get the following error Could not find field 'Description'..

Now when I try and open the Backend I get this error. The database 's:\SOE_CONTROL\SoeControlDatabase\Backend\new_1-8T_SOE_DATABASE_be.mdb' needs to be repaired or isn't a database file.

You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open. Do you want Microsfot Access to attempt to repair the database?

When I click yes I also get Could not find field 'Description'.[/]

Each time I have done this another DB1 or DB2 or DB3 or DB4 table has been created. When I look in the tables I can see that somehow there is a deleted record and it will not let me delete that record. I delete it and then open the table again and the same deleted record is still there.

I hope this is making sense because I sure need help!!

Thanks!

 

[lupins46]

Fixing corruption is trial and error. Her are some ideas.

Create a new empty database.
Import as much as you can from the existing backend; you might find that you can get all of it but if you import tables you think are OK first you can at least get to a point where the problem is confined to a single table (if several tables are corrupt you probably have no choice other than to go to a backup).
If, in the new file, you can copy the structure of the problem table from any good source then you might be able to copy and paste records from the current table into the new one.

 

[willir]

Yea, first step is to make sure you backup your database before attempting recovery.

lupins46 apporach is good.

Another approach to try decompiling...
Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times

Worse case scenario. Your BE database is obviously stored on a server / on the network. So the IT department should have backups for you to restore from. Correct?

Richard