Factory

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 »