Using Access VBA to Query a SQL Server Database
Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.
Using VBA we can do this!
We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.
