FYI It was probably the file 1 that was bad.
You can actually delete the file 3 and reload. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis Fleming Sent: Wednesday, January 04, 2012 9:17 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: File 3 damaged Epilogue: Fortunately we found a recent backup. Autochk basically said that File 3 was trashed with hundreds of: "An index entry contains invalid column names" "Error reading the index list" etc. Changing File 1 to indicate that File 3 is empty should work... next time. Dennis ***** At 12:14 AM 1/4/2012, you wrote: You can trace to the error and see what is going on. Dan ________________________________ From: Dennis Fleming Sent: 1/3/2012 8:00 PM To: [email protected] (RBASE-L Mailing List) Subject: [RBASE-L] - Re: File 3 damaged Thanks Dennis/Dan. When I connect and reload, it only gets part of the way through the tables. Interesting that RBscope 7.6 doesn't pick up an error. Dennis ***** At 08:54 PM 1/3/2012, you wrote: Just rename the db, connect, reload. INDexes will be fixed. The rb3 file is just derived data, db can be rebuild without it. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [ mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, January 03, 2012 4:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: File 3 damaged When you unload the structure and data it only unloads the index commands. It will reload the indexes when it is loaded. You should probably upgrade to 9.1 to take advantages of the new features, performance, and bug fixes. Dan Goldberg -----Original Message----- From: Dennis Fleming Sent: Tuesday, January 03, 2012 2:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - File 3 damaged Unable to open a user's data base using RBase 7.1 "Exception EAccessViolation in module RBENGINE.DLL at ..." I recall that when Unloading Structure and Data you should also include Indexes. RScope reports no errors (???) I guess I can show a file size of zero for the RB3 file and rebuild all the indexes and then get the build index commands from an earlier copy of the data base. But, looking for an easier solution in 2012? TIA, Dennis ***** Dennis Fleming IISCO www.TheBestCMMS.com<http://www.thebestcmms.com/> Phone: 570 775-7593 Mobile: 570 351-5290
