Kath Pelletti
SDSSoftware at optusnet.com.au
Tue Nov 25 20:41:29 CST 2003
Have you tried running Jetcomp on it? http://www.accessdatabaserepair.com/jetcomp.htm HTH Kath ----- Original Message ----- From: Borge Steen Hansen To: Access Developers discussion and problem solving Sent: Wednesday, November 26, 2003 12:46 PM Subject: [AccessD] Corrupt Backend Database - Help! Hi, can anyone help with some direction here, please.... Access97 - corrupt backend database We can see the linked tables in the frontend. When I try and open the backend directly, the database window is empty - shows no tables, queries etc. I get the message that reads : "isn't an index in this table. Look in the Indexes Collection of the TableDef object to determine the valid index names". An attempt to repair using the /repair switch when starting the database does not do the trick. When trying to import the tables into a blank database you get messages about missing index etc etc. So, as it says it's probably the index for one or more of the system tables that handles all the tables etc. in the backend that's screwed up - gone missing..... Any one around that can help here, please ???? Conceptually, I would imagine that it would be possible from a different database run som DAO code that would re-build the indexes of all the system tables or something like that in the corrupt backend Worst case scenario is to use backup from last friday - but the boss has been working all weekend adding and modifying data, so we really would like to salvage the corrupt backend...... Cheers Borge _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com