Working with SQL Server and Access can be challenging, here are 10 things you should know about SQL Server and Access: Using a pure Access solution, (no SQL Server), is almost impossible over VPN, but not a problem at all…
Blog Archives
Why the Project Kickoff Meeting is your most important step
As Access Developers we deal with projects, both small and large, that may span hours or months. Our time is valuable, so it’s important we are effective from start to finish with our client’s projects, in particular with new and…
Posted in Uncategorized
DAO or ADODB? Which one should you use and when?
On my Access with SQL Server group at LinkedIn, one of our members posed the follwoing question: ADO or DAO for new development work? Let’s break it down The question implies DAO or ADODB are mutually exclusive, but they are not.…
Posted in SQL Server
Why you should always use a recordset when executing stored procedures
I’ve talked about using a recordset with stored procedures before, but this time I wanted to emphasize the importance of always using a recordset when executing a stored procedure from Accerss VBA. Command Object does not cut it Usually a…
Posted in SQL Server
Exploring Amazon’s free tier service – EC2 (Free servers in the cloud)
This week’s post is by Manuel Perez, a web developer working in our web division at IT Impact, Inc. Manuel has been experimenting with Amazon’s EC2 cloud service and I asked him to document how to get started on the…
Posted in Uncategorized
