 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Conversion / December 2006CORRUPT ACCESS DATABASE
I have a a serious problem I am failing to open the Access 2000 Database after Windows Advanced Server 2000 decided to close while the database was running. Its now coming up with an error " Invalid format or corupt file" Please assist I have tried so many ways but I have failed. Open Access 2000 and then go to Tools > Database Utilities > Compact and Repair Database. Supply the database name in the dialog that opens. If that fails you may need to get a copy of Jetcomp.exe from microsoft to see if it can repair the database. Post back if neither of those options work. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp > I have a a serious problem I am failing to open the > Access 2000 Database after Windows Advanced Server 2000 > decided to close while the database was running. > Its now coming up with an error " Invalid format or > corupt file" Please assist I have tried so many ways but > I have failed. Lynne -- I hate to bother you, but if you have a moment, could you please explain (a very basic one will do) just WHY the 'compact and repair' function works? After having trouble importing a file into one database (I imported the same file into a different database and it worked just fine, so I realized that it was NOT the file that was the problem), I did a quick search and came across this thread. I ran it, and it worked just great. (Thanks! But this is the second time in a matter of weeks that I've had a corruption problemw ith this database. I'm fairly new to Access, so the first time, I spent a great deal of energy re-building the darn thing. This time, the fix was easy, but I just want to know a.) what it is I'm doing when i 'compact and repair' and b.) if there's anything I can do to AVOID problems in the future If you have a moment to spare, an explanation would be GREATLY appreciated *iris >but I just want to know a.) what it is I'm doing when i 'compact and repair' All the objects in the MDB are copied to a new MDB, indexes are recreated, the original MDB is deleted and the new MDB renamed to the same name as the original MDB. >b.) if there's anything I can do to AVOID problems in the future. See the Access Corruptions FAQ at my website. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Hi Malandite, You can try our product Advanced Access Repair to repair your Access database. It is a powerful tool to recover data from corrupt or damaged Microsoft Access databases that support to repair Microsoft Access 95, 97, 2000, XP and 2003 databases. Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair. And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe Alan Chen DataNumen, Inc. - World leader in data recovery technologies Website: http://www.datanumen.com Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.