This project is a Data Access layer that can be used in any VBA application to connect to SQL Server. The purpose is to keep database connectivity tidy and core database commands centralized within a ...

MS Access Libraries This is a collection of standalone VBA libraries for MS Access projects. This is a WIP, I do not suggesting using in any sort of production project at this time. The basic idea is ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

I can't believe how difficult this seemingly simple task has turned out to be. I need to be able to get a date value stored in an Excel spreadsheet (say, C:\\Temp\\file.xls) in cell B28, and put ...