I have a MS Access database that I need to connect to a MySQL db. I can't be sure what PC the Access db will be opened on and it must work on any office pc that's used. I believe I need to create a DSN-less connection to do this. I created the linked table with a DSN but of course, it doesn't work for anyone else.
I've done some googling and what I get back tells me how to put a connection string in the code. I don't have any code here, no script. If I have to write something in the code somewhere, where does that need to go exactly?