All Records are not visible

M

Mubeen

Thanks a lot for u r suggesstion i have removed the filter
but still i am not able to view the missing record
still when i open the table i cannot see all the records
but when i use access query i am able to see all the records

let me explain in detail
i have inserted records in access using vb.net, after inserting the records
when i navigated through the records from front end i was not able to view
all the records
i was doubtful and opened access.
when i openend the table all the records were not visible but when i used
access query all records are visible.

if further clarifications are required i will provide them immediately

urgent please help
 
J

John Vinson

Thanks a lot for u r suggesstion i have removed the filter
but still i am not able to view the missing record
still when i open the table i cannot see all the records
but when i use access query i am able to see all the records
Click to expand...

Are the records really missing from the table? or perhaps just not
sorted as you might expect? Access Tables have no order; the records
are stored wherever the optimizer finds most convenient. Often this
will be in Primary Key order but you have no guarantee of that!

If you scroll down the table, do you perhaps find the records at the
end? Is the total number of records (visible in the navigation bar)
correct?

John W. Vinson[MVP]
 
Top