Acc97 Missing records

  • Thread starter Thread starter Greg La Due
  • Start date Start date
G

Greg La Due

Anyone have any idea why seemingly random records in a table in Access 97
would disappear?



--
Gregory M. La Due
Twin Tiers Technologies, Inc.
Senior Programmer
(e-mail address removed)
(800) 480-6467
 
Greg La Due said:
Anyone have any idea why seemingly random records in a table in Access 97
would disappear?
Click to expand...

Are you sure they're actually gone and not just that the records are not in
the order you expect? When looking at a table or query without an explicit
OrderBy clause the records can return in a completely arbitrary sequence.
 
Rick

The records are most definitely gone. I have tried compacting and repairing
with no change.

Gregory La Due
 
Back
Top