Invisible records in table

[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

 

[Dorian]

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".

 

[Sandy H]

The record count doesn't show them.

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".

 

[AccessVandal via AccessMonster.com]

These could be due to compatibilty problems between Access and MySQL. How did
you export from MySQL to Access?

I think you would get better answers from MySQL forums. They might have a
solution to this.

 

[Sandy H]

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

 

[AccessVandal via AccessMonster.com]

Hi Sandy,

Have tried to compact and repair your Access database? If you did so, I guess
I don't know of any solution, maybe if anyone can see this thread with
experience may have a suggestion or solution.

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

These could be due to compatibilty problems between Access and MySQL. How
did

[quoted text clipped - 27 lines]