Missed Records in Table after Compacting and Repairing

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • shalini0702
    New Member
    • Oct 2006
    • 2
    #1

    Missed Records in Table after Compacting and Repairing

    Hi,

    I am facing problem of Missing Records in Table after Compacting and Repairing. Suppose my table had 486 records before compactig and after compacting I see only 485 records, One records has been automatically deleted can any one tell me what is the problem that is with Msaccess

    Thanx
    Shalini
    Tags: None
    • JohnFitz
      New Member
      • Sep 2006
      • 3
      #2
      What vrsion of Access? Compacting usually has no effect upon "the records". Perhaps the missing record was full of "air" and is gone. One record out of how many?

        Comment

        • PEB
          Recognized Expert Top Contributor
          • Aug 2006
          • 1418
          #3
          Hi,

          This may be provoqued if the record doesn't respond to the database integrity! Sometimes when the electricity falls and You don't have an UPC the record is saved but wrongly... And the database is corrupted...

          After repair all records that were temporally are deleted and the integrity of the database restored...

          I think that this record isn't a big loose for your database!

          :)

            Comment

            Previous template Next
            Working...