I have a MYSQL database which I am using data from to my Access Database through the ODBC. In my Access I have the linked tables from the MYSQL. I created my own Tables and there is a filed in my Table which is related to a key field in one of the linked Tables from MYSQL to retrieve some info. I have had this running for about a year without an issue. However recently I have run into an issue on 2 laptops from the from the 6 laptops which run these databases. When I go to certain records from the linked tables the data all appears as #Name?
However retrieving the same records on the other 4 laptops have no issue. I am trying to figure out what would cause this. I have checked the memory as well as the Regional settings but can't see any difference on these 2 laptops from the other 4.
Any ideas would be very helpful.
Thanks,
Sam