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 [...]
A poster asked me a wonderful question: "How do I get Access [linked to SharePoint] to remember my login credentials so I don't have to login every time?" The answer to the question isn't simple as it should be and hence, I felt an article on the subject would be helpful for those who want to automa [...]
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 [...]
As Juan may have mentioned earlier, I had been working with two other MVPs, Tim Runcie and George Hepworth in producing the first of its kind, a book dedicated to using Access with SharePoint. The book can be bought online at the Advsicon store. If you're wanting to learn more about the capabilities [...]
One advantage a SharePoint list has over any ODBC data source is that Access can disconnect and re-connect and synchronize the local edits back to the server fairly seamlessly. It also provides a friendly conflict resolution management, all out of the box. This is available whether you're using a tr [...]
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 [...]
We develop solutions using Access on the desktop and SQL Server on the network for clients throughout the US. Our standard method is to log in to the client's network via VPN and program on their server since we couldn't program on our development machines using the credentials provided by our clien [...]