Issues with Access and Windows 7 64bit
Some of my clients are experiencing terrible performance in Access when using Windows 7 64 bit.
SQL Server Connections Strings for SQL Server
All the information you need in creating connection strings for Microsoft Access and SQL Server.
Use CrossLoop to provide support to your clients, or your Mom
Use CrossLoop to support clients remotely.
Great backup tool for SQL Server Express
SQL Server Express has no automated backup tool, you must do all backups manually or use scripts to automate nightly backups. (You do backup your production databases every night right?). SQL Backup and FTP SQL Backup and FTP is a program I've been using on my Production Server for the past month, a [...]
SQL Server + TSQL Deep Discussion on February 24th
On Thursday February 24th I'll be presenting at CAUG, (CAUG.com) the following topic, if you're in the Chicagoland area please join us or you can tune in via the web: SQL Server Express has been the best thing to ever happen to Access, the two make an unbeatable combination! But to maximize the rela [...]
Gain more space in your reports – Use a new date format
Dates on reports can be a pain, you have to leave enough space for the worst case scenario, usually 12/12/xxxx, if you have a lot of date columns all that space can add up. Instead of using Short Date in the format field of the report's format tab, use mm/dd/yy instead. It will guarantee all months [...]
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!
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 [...]
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 [...]
A new focus for my blog: More code and techniques!
I'm switching gears on my b log to less commentary and more code in 2011! (I guess this post is considered commentary so it's going to be the next blog post when I switch gears). It's not to say I won't comment on the state of Access consulting, SQL or other topics, but rather I want to keep you g [...]