Ring in the New Year with some new ideas for your applications as we take a look at using Web (REST) Api's in Access. With just a bit of VBA and a couple of great libraries, you can make use in your applications of any data source on the Internet. We'll take a look at reading from a publicly-available API, as well as creating our own Web API from a SQL backend and using it for full CRUD operations in Access!
George first encountered Microsoft Access when using the thirty-plus floppy disk versions of Office to teach Statistics and MIS in the early 1990’s. It’s been true love ever since. George has worked as a software developer for the past twenty-five years, half of that time at Microsoft (in just about every group other than Office). He is the founder and president of Dawson Butte Software, working primarily on .NET applications (often with Access somewhere in the mix). George still has a commercial site or two that is driven by an Access database sitting in the server file system.