Jim Lawrence
accessd at shaw.ca
Sun Jun 1 11:09:23 CDT 2014
Hi Bill: Can you open the database period? If you can you then can copy table by table to a new database. I have done that more than once, in my career, especially when all other methods have failed. The next question, is what caused the database error. I have found if database's tables are left open, across a network, for an extended period of time or closed without being properly shut down, data corruption will slowly creep in and eventually make the system unusable. Jim ----- Original Message ----- From: "Bill Benson" <bensonforums at gmail.com> To: "Microsoft Access Database Discussion List" <ACCESS-L at PEACH.EASE.LSOFT.COM>, "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Sunday, June 1, 2014 3:29:45 AM Subject: [AccessD] corrupt database - backup rather out-dated. Posting to both lists because this is urgent My Ac2013 Accdb started being corrupted for "no" (known) reason, my suspicion... maybe my PC ran out of juice while on Standby, or maybe standby itself caused the problem. It is completely unusable, I can open it and get an error message that says 'Id' is not an index in this table (it never tells me what table), about 3 or 4 times; then any object I try to open I get that same message 10 to 20 times, including all modules and linked tables. Eventually some tables will open. Modules (which is what I am really after, I spent a lot of time coding) never. I have not been able to import anything into a fresh database either. I cannot get to the VBE inside it. Does someone have a way to repair or crack this accdb open piece by piece to get at its parts? I would be happy to send it to you, it is just my work, no client data yet. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com