DSN

How To Connect Access To MySQL

In this post I am going to show you how to connect to your MySQL web database from your Access desktop database. Here are the steps: 1. MySQL table 2. Access MySQL ODBC connector 3. Link table from Access 4. Create search form. (in part 2 of this post) I am going to use the […]

Continue Reading

How to programmatically create an Access DSN

When I was working on a project at Exxon, I had to load Access on startup to connect to a DSN. Here is how I implemented it (I don’t remember where I found the code):

Let me know if you have any questions.  

Continue Reading




 

Call Erik Now