Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question

Doug Steele has provided code to do this for you. I use it in all my SQL Server/ODBC applications. I program on a machine with a DSN defined, and when I add a linked table/view using the DSN, I immediately run his code to convert it to a DSN-less connection. It works great.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .