Search Again: Re: Recover cmd / Lost Data From: Shawn Hogan Date: Sunday, January 3, 1999 Time: 2:36:48 pm Webmaster - RJS Online wrote: >We just recently obtained the 100 user license of Optigold ISP and love >it!!! It is a perfect fit for our ISP organization. I will be contacting >your company Monday. In the mean time we are testing it with a live >billing. We have about 90 users we invoice on the 1st to 3rd and we have >invoiced about 40 so far. The problem is the power flashed and the computer >locked up. When Optigold ISP was restarted ot said to run the recover >program on multiple files. MainMenu, Invoice, LineItm, etc. I can not find >the recover program. Help!!!!! We need to get these invoices out by Monday >AM. I have also tried renaming the existing Optigold and reinstall the >software and copy over the existing files in question from the install to >one central location from both directories. This did not work as you may >know. >Is this common with FileMaker DB structure. >Thank you for reply in advance, (true test of Support on a Sunday afternoon) Well, if power went out in the middle of generating invoices, it probably not a good thing. {grin} Since it's heavily reading/writing to 3 tables (MainMenu, Invoices and Line Items) at that time. Which is why you will need to recover them. Anyway, the recover command isn't part of FileMaker Pro Runtime (don't ask me why). So... in order to use it, you need FileMaker Pro 3.x or 4.x (non-runtime). If you don't have a copy of FileMaker Pro, that's okay too, because you can download the trial version of FileMaker Pro from their website (www.filemaker.com) and it has a fully working Recover command (it's on the File menu). When you recover the files, it will name the recovered ones as: "MainMenu Recovered.USR, LineItm_ Recovered.USR and Invoice_ Recovered.USR". Delete (or move) the originals, and then rename the recovered files to their original name... (MainMenu.USR, LineItm_.USR and Invoice_.USR). And all should be well. It may be a good idea to rebuild the indexes (in maintenance) before you continue with the invoicing... - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647

Messages In This Thread: Recover cmd / Lost Data by Webmaster - RJS Online on Jan 3, 1999 at 2:24:44 pm Re: Recover cmd / Lost Data by Shawn Hogan on Jan 3, 1999 at 2:36:48 pm Re: Recover cmd / Lost Data by Rob Smarzik on Jan 3, 1999 at 5:16:39 pm Re: Recover cmd / Lost Data by Shawn Hogan on Jan 3, 1999 at 5:26:25 pm