Desmond Lloyd wrote: > Good Morning All, > > Has anybody seen this before?: > > Modified version of SBT Accounting, been running for years with support for > Work Orers, Sales Orders etc. Been running fine, approximately 100 users > (+/- a few). Running on old Windows 2K Server, plenty of drive > space/resources. > > Have been getting an intermittent "RECORD-NOT-AVAILABLE" message that scrolls > in gray window afters users have updated a record. (primarily in the work > order section). It gets the names of the field names and then compares the > original values to memory variables, if they have changed they write a new > record to an audit file that contains the key (wo in this case), new value, > date, time and user ID. Besides this update and the update to main data file > (work order once again), there is no direct activity accessing any tables. > Have reduced the size of the audit file to about 3 million records. Record > wise it's big but size wise (bytes) it isn't the biggest. > > > > A Google search and a reference to an old MSDN article suggests that I either > turn off Novell Transaction tracking (lol), possibly modify the locking > scheme. > > > > One thing I did do was to create a temporary file for each individual write > to that file and then append the main. This seemed to work for awhile but > has come back... > > > > HELP! > > Anyone ever seen this before?
Reminds me of an issue I had on Novell with VFP5/6 about 10 years ago. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
