Blog

Curious about the latest Access features? Join Access insiders!

If you're on Office365 you have a choice in regards to how often you see new features, (some refer to these as rings): Semi-Annual: You get new features every six months, we recommend this channel to all of our clients Semi-Annual Targeted: Think of targeted as a preview of what users will see a mon [...]

Curious about the latest Access features? Join Access insiders!2020-03-27T12:07:53-05:00

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 Summit2020-03-25T17:52:28-05:00

New Access features coming your way!

Never discount looking at the What’s New section in Microsoft Office to get a first hand look at goodies coming your way! A fellow MVP pointed out to me how you can see new features by going to backstage, (File menu), clicking on Account and then What’s New. Scroll down until you see new features in [...]

New Access features coming your way!2020-02-28T12:32:51-06: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 Server2020-02-07T14:47:57-06:00

[UPDATED 2020-01-23] 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 an identity column, causing different errors. If you receive errors [...]

[UPDATED 2020-01-23] Office 365 Build 1912 breaks ODBC linked tables’ identity2020-01-23T14:22:46-06:00

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

[UPDATED 2] Critical: Office Update breaks Access — Query is corrupt2019-11-27T15:39:43-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!2019-10-31T11:21:03-05:00

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 Authentication2019-10-03T07:06:12-05:00

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 so that other employees can see the an [...]

Access with Power BI2019-09-08T20:26:01-05:00