Office 2013 has gone on sale and already I've seen posts online from people asking about the SQL Server Upsizing wizard not found in the tool. It's no longer available The wizard was a causality in Access 2013 and frankly I say good riddance. I for one thought it was barely usable when it worked, si [...]
10 Question you Should Ask your Access Developer Companies are constantly looking for quality Microsoft Access developers, here are some questions to help you evaluate one: Do you provide quotes or estimates? If the MS Access consultant does not provide estimates, it's a major red flag. Quotes an [...]
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 prim [...]
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 [...]