Join me this Wednesday, January 4th at 6:00 PM EASTERN, 5:00 PM CENTRAL, at the monthly CTAUG, (Connecticut Access User Group), meeting. We will be discussing how to optimize Access with SQL Server: What is the ONE field all of your tables in SQL Server should have? (Hint: It's not just the a prima [...]
Queries, reports and emails, all standard stuff for Access, but sometimes you need more options, something innovative that will allow you to do more then you ever thought Access can do, thats where IF THIS THEN THAT comes into play, (www.ifttt.com). ifttt.com allows you to extend Access' capabiliti [...]
I was late to the ADP party, having discovered their power for a project I needed to do on a multi-franchise national database. I had started using a regular Access file but quickly grew disenfranchised with the record locks and other issues that propped up. The ADP proved great in both reliability [...]
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 [...]
