I have several linked tables from MySQL in Access. Only two of the tables, which are updated from access show all deleted data in the columns when I open the tables in access. But when I open them in MySQL the data is fine. Anyone have any insight to this?
I am not experienced with this but do your tables all have primary keys? Do any of the primary key fields allow nulls? Do you have timestamp type field?
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.