[UPDATED 2020-01-23] Microsoft Office 365 Build 1912 Breaks ODBC Linked Tables’ Identity

Microsoft Office 365 Build 1912 Breaks ODBC Linked Tables’ Identity **** Only applies to users on Access with SQL Server table links, otherwise this alert does not apply **** We are getting early reports that the build 1912/2001 released with Office 365 may break the ODBC linked table that contains [...]

Ben Clothier2021-06-11T05:26:27-05:00January 16th, 2020|

[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt
[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt

Blog

[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt

We've gotten reports from our clients, our colleagues and other posters that there is a huge problem with the Office 365 update that was released yesterday (November 12, 2019). The update causes an error where it may say: "Query "" is corrupt" This post deals with both preventive and restorative mea [...]

Ben Clothier2021-06-10T10:40:40-05:00November 13th, 2019|

The Microsoft Office Product That Refuses to Die

The Microsoft 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 [...]

Juan Soto2021-06-11T05:27:47-05:00November 9th, 2019|

You Can Now Use Access with Microsoft Azure MFA!

You Can Now Use Access with Microsoft 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 [...]

Juan Soto2021-06-11T05:28:49-05:00October 31st, 2019|

7 Step Guide to Using Access with Azure Multi-Factor Authentication
7 Step Guide to Using Access with Azure Multi-Factor Authentication

Migrating to SQL Server, Access Help, Blog, Uncategorized

7 Step Guide to Using Access with Azure Multi-Factor Authentication

7 Step Guide to 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 [...]

Juan Soto2021-06-11T05:29:42-05:00October 3rd, 2019|

Using Microsoft Access with Power BI
Using Microsoft Access with Power BI

Blog, Access Help

Using Microsoft Access with Power BI

Using Microsoft Access with Power BI We recently had a client who wanted to view his QuickBooks data in Power BI, but the former could not connect with the latter to get the data, so we resorted to exporting the data from Quickbooks, using Access to clean it up and finally upload it to PowerBI.com s [...]

Susan Pyne2021-06-11T05:30:39-05:00September 8th, 2019|

Microsoft Access is NOT Dead and Neither is VBA

Microsoft Access is NOT Dead and Neither is VBA Catch my latest podcast on why Access is not dead! Episode 1: Introduction to the podcast Episode 2: More great examples of why Microsoft Access rocks for business Episode 3: Why Microsoft Access is NOT going away Episode 4: Best practices for Microsof [...]

Juan Soto2022-01-07T09:06:01-06:00August 17th, 2019|

Netherlands Access Developer Day 2019 – 14 September

Netherlands Access Developer Day 2019 – 14 September Access developer day is quickly approaching and you still have time to register and get a discount. It promises to be a great experience with the Access team and some of the brightest Access developers in the world. To register and learn more deta [...]

Juan Soto2021-06-11T05:32:18-05:00August 8th, 2019|

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation
Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation

Uncategorized, Access Help

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation

Catch my 'Optimizing Microsoft Access with SQL Server' Presentation Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in [...]

Juan Soto2021-06-11T05:33:14-05:00August 6th, 2019|

Gotchas When Using Microsoft Access Runtime

Gotchas When Using Microsoft Access Runtime We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runt [...]

Juan Soto2021-06-11T05:33:54-05:00July 19th, 2019|

Using OASIS-SVN and git for Access source code control
Using OASIS-SVN and git for Access source code control

VBA, Access Help, Uncategorized

Using OASIS-SVN and git for Access source code control

NOTE: I will be talking about this topic in depth in the upcoming Access and SQL Server monthly webinar on July 9th at 6:30 PM CDT. Register so that you can view the process live and ask questions! As we work with several applications and sometime in a team, source code control is pretty impo [...]

Ben Clothier2022-01-07T09:04:42-06:00July 2nd, 2019|

Blog