ODBC

How To Connect Access To SQL Server On Amazon Virtual Machine

In this post I am going to show you how you can connect your Access database to a Microsoft SQL Server 19 running on an Amazon Virtual Machine. Something great about the current technology is that you can have a version of something that would cost you BIGGGGGGGG Money in the past! In this case […]

Continue Reading

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): Private Sub Form_Open(Cancel As Integer) ‘#####================================================================================ ‘## ‘## ‘## Purpose: ‘## For use in scripts that require SQL System DSNs […]

Continue Reading