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 […]
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 […]
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 […]