Sometimes, we have recurring tasks that we would like to simplify and when those tasks involve interactions with the Access object model, we certainly don't want to miss out on the built-in intellisense. Do you have any intellisense? At IT Impact we frequently open forms in our code with a where cla [...]
I've been seeing a lot of talk lately about linked SQL Server tables...ever since I've started this blog I've address it several times, but there have been some changes since my last diatribe that warrant revisiting the issue again. Linked SQL Server Tables - Should you use them? YES! Linked tables [...]
Recently we were invited to a product interaction session with the Microsoft Access team, it was a wonderful opportunity to discuss what we would love to see in the next version of Access and I'd like to share my responses with you and get your feedback. If you had $100 to spend on new features, how [...]
Today we debut a new site design! Let us know in the comments if you like it. Thanks! Juan (Editor in Chief) [...]
THIS EVENT HAS ALREADY PASSED. STAY TUNED FOR MORE EVENTS IN THE FUTURE Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to won [...]
Getting up and running on Office 365 Preview was not easy for me, there were a few gotchas through out the process and it became a frustrating experience. Lucky for you I've created a video that will walk you through the whole process! Why bother? Access 2013 is a big game changer to the prior versi [...]
My Access Kung-Fu is strong, join me on September 11th, 2012 as I demo advanced topics Live from Microsoft's campus in Redmond and the Seattle Access Users group: Access Kung-Fu! Join me next Tuesday, September 11th, 2012 for our second world wide session. Topics to be discussed: Master the use of T [...]
There are two main means of achieving the design goals of a multitenant database system – in Part one, we outlined the issues when using a physical database separation design. Here we will look at logical separation design and the suggested implementation techniques. Logical Separation: Less secure, [...]
Microsoft Access 2013 Upgrade is out and both Ben and have been experimenting with it for sometime now. Here are 10 things we love about the new Access web services: 1. It's SQL Server-based. (Ben) It used to be that Access had its own database engine, known originally as JET and now called ACE. We [...]
I've been traveling the USA for the better part of two years talking about how to rev up Access with SQL Server, after hundreds of attendees, many miles traveled and more road meals than I care to remember, I finally got around to recording it. Here it is and PLEASE leave a comment below! https://yo [...]
Had a great chat with Robert Crane and the Computer Information Agency about starting an Access practice, when Access is a great tool for business and how to obtain new clients. You can hear the podcast here: Let me know your thoughts in the comment section below! [...]
