After a lot of resistance I have recently been given MySQL access to our CRM system, via a read-only slave.
I have an issue now in that I am really limited to what I can do with the data in MySQL - cannot create views etc. The IT head said I should continue to use Access, with the tables from the slave imported using ODBC connections. I can do this but I'm not sure it's the best plan long-term - I had planned to move my processes into MySQL.
Is there any way around this? Can I somehow link the read-only tables to another MySQL database which I can edit?