He specializes in Access with SQL Server databases
His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, .
Stable and efficient environment with SQL Server
He’s a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73.
If you wish to have Juan speak at your next group meeting you can contact him.
[email protected] I’ve earned my Access MVP award for another year , here’s how I did it I’ve earned my Access MVP award for another year, here’s how I did it.
I often get asked, “how does one become an Access MVP?” 9 Years of MVP Awards When I first started nine years ago, we had over 30 MVPs.
Now we have less than 20.
Each year, I need to compile my accomplishments and submit them for review, then cross my fingers and hope to be awarded.
It’s not like [.
] I’ve earned my Access MVP award for another year
here’s how I did it.
[UPDATE: now with Access team link to fixes] Recently the Access team starting working on a new data type called Date & Time Extended, here’s Ebo Quansah, Access program lead: Very soon, we will ship a new data type, known as Date & Time Extended, which enhances syntax compatibility with SQL [.
] New data type coming to Access is causing problems
here’s how to fix it 2020-06-10T11:16:14-05:00 Free Field Hospital Database to Fight this Pandemic Free Field Hospital Database to Fight this Pandemic.
Field Hospital Inventory System During these grave times we see field hospitals going up everywhere: Central Park in New York, churches, gyms, parking lots, and more.
The COVID Supplies Database is our way of helping humanity in this time of need, its a simple inventory system that’s easy to use , co [.
] Free Field Hospital Database to Fight this Pandemic 2020-05-13T20:02:09-05:00.
My thoughts on this year’s 2020 MVP Summit
My thoughts on this year’s 2020 MVP Summit.
Last week we had our virtual MVP conference, where I huddled with MVP’s from around the world as we heard and gave feedback to the Access team.
Here are some takeaways: I miss sharing with friends I only get to see once a year, but being virtual did have some advantages, one of them being able to re [.
] My thoughts on this year’s 2020 MVP Summit 2020-03-25T17:52:28-05:00.
Learn how to performance tune SQL Server
Please join me on February 11th, 2020 when I’ll have special guest Jacob Golden from https://www.imyourdba.com/ to discuss how you can improve the performance of your database on SQL Server, can’t miss talk.
Learn more here: https://accessusergroups.org/sql-server-with-access/event/375-2020-02-11/ [.
] Learn how to performance tune SQL Server 2020-02-07T14:47:57-06:00 The office product that refuses to die?.
Several of you have sent me an article on Medium.com asking my thoughts on it: Microsoft Access: The Database Software That Won’t Die I agree with some points and am amazed that the author completely missed one point in particular.
Access is sooo easy to use that
I agree with his point that it’s [.
] The office product that refuses to die.
2019-11-09T13:53:10-06:00 You can now use Access with Azure MFA!.
With the latest release of the OLE DB driver Access developers can now implement Azure multi factor security into their applications, (previously the latest version of SQL Server ODBC was the only supporting the technology), allowing them to run code in VBA that is compatible.
I recommend using the [.
] You can now use Access with Azure MFA
Using Access with Azure Multi-Factor Authentication
, , Migrating to SQL Server,.
Using Access with Azure Multi-Factor Authentication.
One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days.
Step 1: Extend your domain to Azure AD Before you can enable MFA in Azure you need [.
] Using Access with Azure Multi-Factor Authentication 2020-06-29T08:37:42-05:00 Access is NOT dead, (neither is VBA).
Catch my latest podcast on why Access is not dead
] Access is NOT dead
(neither is VBA) 2019-08-17T16:10:06-05:00 2 Enter your email address:.
Blog Archives Select Month August 2020 (1) July 2020 (1) June 2020 (2) May 2020 (1) March 2020 (2) February 2020 (2) January 2020 (1) November 2019 (2) October 2019 (2) September 2019 (1) August 2019 (3) July 2019 (2) May 2019 (1) April 2019 (1) March 2019 (4) February 2019 (2) December 2018 (1) November 2018 (1) September 2018 (3) July 2018 (1) June 2018 (2) May 2018 (2) April 2018 (3) February 2018 (1) January 2018 (2) October 2017 (2) September 2017 (2) August 2017 (1) July 2017 (1) June 2017 (1) April 2017 (2) March 2017 (1) February 2017 (1) November 2016 (2) October 2016 (2) September 2016 (1) August 2016 (1) June 2016 (1) March 2016 (1) February 2016 (1) September 2015 (1) August 2015 (3) July 2015 (2) June 2015 (2) April 2015 (4) March 2015 (2) February 2015 (1) December 2014 (1) November 2014 (2) October 2014 (3) September 2014 (3) August 2014 (2) July 2014 (2) June 2014 (2) May 2014 (3) April 2014 (1) March 2014 (2) February 2014 (2) January 2014 (4) December 2013 (1) November 2013 (3) October 2013 (3) September 2013 (3) August 2013 (1) July 2013 (2) June 2013 (3) May 2013 (3) April 2013 (2) March 2013 (3) February 2013 (2) January 2013 (3) November 2012 (2) October 2012 (3) September 2012 (6) August 2012 (1) July 2012 (5) June 2012 (2) May 2012 (4) April 2012 (3) March 2012 (3) February 2012 (3) January 2012 &.
Powered by • We are a Microsoft Access Development Company with Headquarters in Chicago
We have clients in Miami and Orlando – Florida, Dallas – Texas, Puerto Rico, New York.
Large client base in Houston – Texas, San Francisco and Los Angeles – California, Washington, Denver – Colorado.