Invisible records in table

  • Thread starter Thread starter Sandy H
  • Start date Start date
S

Sandy H

Hi
I have a weird thing happening with one of my systems. I have an online
MySQL database that stores customer records. These are downloaded to my
Access database and stored in a table.

For some strange reason, some of these records are invisible even though
they are there. When I view the data in the table, some records are
missing. If I write a query to pull out all the customers from the 27/07/09,
they are still invisible. But interestingly, if I pass the customer_id to
the query to find that record alone, it suddenly appears. Remove the
customer_id criteria and it's gone again.

My forms are showing the records as they should but I can't view them in the
table. I have checked the data and can't find anything wrong. I have checked
to make sure I haven't saved a table filter and I haven't.

Has anyone else ever seen this happen and any idea why. I can't work it out.

Thanks in advance
Sandy
 
What do the record counts say, do they reflect that the rows are missing?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
The record count doesn't show them.


Dorian said:
What do the record counts say, do they reflect that the rows are missing?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and
they
eat for a lifetime".
Click to expand...
 
Thanks for the idea about MySQL but unfortunately, I don't think this is the
problem.

I have a linked MySQL Table that you can see the records in. I do a direct
INSERT sql statement from the MySQL table to the identically structured
Access table. Up until the last week, 100% of the records came in the way
they should. The system has been running for about 5 years and I have never
seen this problem before.

Out of the last 100 records, about 9 became invisible - yesterday, 26 new
records came in and all were visible. I can't seem to find a pattern for
what is causing the problem. They are there, they just aren't showing in
table view but they are showing in form/report view.

Thanks
Sandy
 
Back
Top