Optimize SQL Server with Access on a WAN
Access with SQL Server is a great combo, but you do need to be aware of certain issues and optimize the relationship to make it a rewarding experience for your users. This article will talk about the steps you need to take and how to avoid some pitfalls.
Easy ADODB Recordsets and Commands in Access
Using ADODB recordsets and command objects in your Access code can be daunting, but you can greatly simplify it by using the code in this article.
Amazon $25 Gift Card!
Hello there, I have a free $25 Amazon gift card for my subscribers! All you have to do is leave a comment below, any comment really but if it’s Access related then all the better! I will pick one comment at random for the winner, contest ends January 19th and only one comment per person! [...]
Multi-Session Global Variables
Global variables are a wonderful way to make your code consistent, powerful and easy to use, but the native Access global variable, one declared in a stand alone module has a critical flaw: it will reset if there is a problem in your code, and it does not retain it’s value once you close Access. Use [...]
