Alpha DevCon 2018
Page 3 of 3 FirstFirst 123
Results 61 to 64 of 64

Thread: Losing records VERY WORRYING

  1. #61
    Member
    Real Name
    John Tary
    Join Date
    Jan 2007
    Posts
    418

    Default Re: Losing records VERY WORRYING

    Update: I am keeping my fingers crossed at this point as this issue has not happened for about a month now. I have tried everything under the sun and still am not quite sure what the fix was but I have a general idea. I thought for so long that this was a NAS issue and finally convinced IT to move to an actual server, this did not change the blanking behavior. I then had to get the virus scan restrictions lifted for the files, this too had not effect. I ended up doing a redesign of some sets which allowed me to delete several indexes that had an expression and filter. In addition, my set also had a one to many link using a multiple field link which created some other indexes that I could then delete. So far so good. It has been 4 years of this, loosing a few records a week. I am cautiously optimistic for now. The frustrating thing is there was really nothing wrong with what I was doing, yet the issue still existed.
    Last edited by johngtatp; 10-15-2015 at 10:01 PM.

  2. #62
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,857

    Default Re: Losing records VERY WORRYING

    Thanks John,

    I was never a fan of sets built on multiple fields. Nor do I care for indexes built with filtering and/or expressions. Maybe these have kept me out of trouble.
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  3. #63
    Member
    Real Name
    Wale Lasaki
    Join Date
    Apr 2012
    Location
    Abeokuta
    Posts
    29

    Default Re: Losing records VERY WORRYING

    If alpha five is still using . dbf as it's extensions, this type of thing will be happening.
    Can it be changed?

  4. #64
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,430

    Default Re: Losing records VERY WORRYING

    Quote Originally Posted by lascvent View Post
    If alpha five is still using . dbf as it's extensions, this type of thing will be happening.
    Can it be changed?
    The alternative to dbf is to use DAO to connect to another data source.

    It is available as an active link tablee as the closest alternative, but is a level if complexity higher then the native dbf.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

Similar Threads

  1. losing records on network
    By martinwcole in forum Alpha Five Version 5
    Replies: 0
    Last Post: 01-05-2007, 03:55 AM
  2. LOSING RECORDS
    By Russ Goeckner in forum Alpha Five Version 4
    Replies: 4
    Last Post: 07-03-2003, 01:11 PM
  3. Losing records
    By Beltronics in forum Alpha Five Version 4
    Replies: 14
    Last Post: 07-01-2002, 06:14 AM
  4. Losing records in a browse
    By Jay Talbott in forum Alpha Five Version 4
    Replies: 14
    Last Post: 09-02-2001, 09:25 AM
  5. trouble losing records
    By Trevor Johnson in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-18-2000, 03:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •