Building a Data Access Layer in VBA for SQL Server
In this post, I thought I would share some ideas about creating a Data Access Layer in VBA for SQL Server. The idea behind creating this layer is to organize all the low level coding tasks associated with accessing a SQL Server database into one area in an application. Typically, these tasks involve writing methods using ADO (Active Data Objects) to either fetch data or …
Building a Data Access Layer in VBA for SQL Server Read More »