I have a program that stores it's data in an MYSQL database. I created an ODBC connection using a Read-Only user to read the information from the Tables and linking them to my own Tables in Access to pass the information through to my forms and reports. This has been running well for the past few months since I created it.
This week, they had this program used as a second instance which stored a second instance in the MYSQL database using a different port. I created a second ODBC connection to this instance to use in Access similar to the first. I copied my first Access database and in the second Access copy, I went to the ODBC Linked Manager and changed the tables to the second instance.
When I open any of the Tables, I do see the data from the second instance. I can run queries on any tables in the new Access database and have the ability to add new records. However, In both Access databases, I have Queries which have Tables from this access database as well as fields from the linked Table from the Read-Only MYSQL database. However, in my first Access database, I am still able to add records to the Table through the Query. However in my second Access which is copied from the first in these queries, it will display the records but not allow me to add new records.
I spent a good hour comparing both tables and queries and properties and can not see anything different in the second database from the first. If I remove this linked Table from any of the queries I am able to add records once again.
Any one have any idea where I should look to resolve this.
Thanks,