If you're having a hard time convincing management to use Access with SQL Server, then use this post as ammunition to get your point across: Reason #1: Security I've walked into situations where new clients are storing their customer's credit card info, (including the three digits on the back), alon [...]
I'll be presenting at this month's Chicago Access User's Group. (www.CAUG.com) It will be broadcast-ed live via the web as I present my newest topic: Access Kung Fu - Tap into your inner VBA Sensei We will discuss three topics, TempVars, Enums and Classes. TempVars are a great way to store global va [...]
If you've ever asked Access to do a join between a local Access table and SQL Server table (which is called a heterogeneous join) you may have experienced first hand how slow it can be to process results. The situation could be vastly superior if you can afford to download the SQL table as a tempora [...]
Hosting on the web is a hit or miss, you will find a wide range of providers, from dirt cheap hosting companies that will lump you in with hundreds of other databases, to premier firms that will rent you a server all for your self. Many traps to avoid If you're not careful you may end up with a host [...]
Our Access/SQL Server/SharePoint practice benefits from great tools on the web, some free and some not, and I'd like to share our experiences with you. LogMeIn.com (Free) and LogMeIn Ignition (Subscription) for Windows We usually use the Remote Desktop Connection when working with our client's syste [...]
Those of you caught with the Windows 7 SP1 bug that rendered your development computer useless for Access 2007, (including yours truly), can read up on the official Microsoft response to the issue here: http://blogs.msdn.com/b/psssql/archive/2011/10/03/yes-we-made-a-mistake-and-are-finally-going-to- [...]
I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here: http://blogs.office.com/b/microsoft-access/archive/2011/11/28/display-real-time-information-with-the-controltip-property.aspx Please read and come back here for some final thoughts on the techn [...]
A while back I wrote about a Inner Join technique using a date range. (You can find that post here.) Today I'm going to take it a step further and discuss using inner joins to another query and conclude with an issue in Access you may shed some light on. Using Queries as Inner Joins For the longes [...]
A while back I talked about a problem one of my clients was having with Windows 7 64 bit and Access 2010/2007. It was terribly slow and unacceptable. You can see the original post here. Solution Found - Turn off the LLMNR Protocol My client waited long and hard to get this resolved, but Microsoft di [...]
Creating a primary key using that is also a auto increment field in code can be challenging. This article will discuss how to do so in two steps.
I'll be presenting on using Access with SQL Server as a business intelligence, (BI), tool and will cover the following three areas: Using SQL Server as a dashboard agregator with Access Creating powerful Crosstab queries in Access Using Pivot Table Tools Creating Sub-Totals in both Crosstab and Pivo [...]
