Sage 100

 View Only
  • 1.  Blank record in SY_USER

    Posted 08-21-2025 12:23

    Sage100 version 2024 advanced.  Just had the issue where a blank (null) record in SY_User stopped everyone from printing.

    Does anyone know what might cause this record to be created ?

    Thanks,

    Jeff



    ------------------------------
    Jeff Fiddelman
    DSD Business Systems
    ------------------------------


  • 2.  RE: Blank record in SY_USER

    Posted 10-03-2025 20:22

    I have had this occur for 2 clients recently.  Both on Advanced.  One on 2023, the other on 2024.  The one on 2024 just recently upgraded, and it's occurred for them twice in a week's time.  Neither has ODBC Security enabled.  I've been using DFDM to delete the blank record, which is the first record in the file.  There's a Sage KB on this, which I followed to remove the blank records.  Any insight on what might be causing this?



    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------