Ed,
You aren’t doing this from a form, are you? You cannot disconnect a database while you have a form open (unless it is an external form.) There is probably some other explanation. One thing you could do instead of the disc/copy/conn is output to a file, unload data, output screen then archive the unloaded data. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Ed Rivkin Sent: Friday, September 11, 2009 11:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Strange Update I am curious if someone has faced a similar situation. The problem revolves around a .rmd file originally written for my application 20 years ago using r:base 4.0. I update a table monthly with 140 entries; one for each account. To do so, I print a report to disk, load it into a table and append the table to my master table which is the current Rent table. In addition all rows for accounts with a zero balance are moved to the Rent History table and deleted from the Rent Table Prior to the print / load / append the DB is disconnected and the DB is copied so I have a recovery point in case something fails. The only changes from 4.0-4.5 - 7.6 are the screen handling messages. After testing the conversion everything seemed to work fine. Running parallel we are having a strange problem. Many of the current Rent records are duplicated, others tripled and quadrupled and some of the history data is finding it's way back into the Rent file. When I commented out the Disconnect / Copy to Disk / Connect everything worked fine again. Am I hitting some sort of DB corruption issue? Should I put a Pause for 30-45 secs after the connect? Or am I totally missing something else. Thanks as always, Ed
