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 ...

If 2K or above, ADO is the default data access library; and ADO Recordsets do sort properly.<BR><BR>Having said that, I would still prefer to use an ORDER BY clause in the SELECT statement.

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the ...

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 ...