Alternative Solution to DCount and DLookup with MS SQL Server Backend One of the major issues we have encountered with Access is the use of DLookup and DCount when using SQL Server tables. We recently worked on migrating a pure Access solution to SQL server and encountered delays on the load [...]
Search Microsoft SQL Server Database for Stored Data Have you ever had to decipher a database and identify which column has the data you need? I recently had to work with extracting data from a SQL database to use in Microsoft Access and Power BI, unfortunately the naming structure of the dat [...]
How to Fix the New Data Type That is Causing Problems to MS Access [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 [...]
Free Field Hospital Database to Fight the COVID-19 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 o [...]
Curious About the Latest Microsoft Access Features? 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: [...]
Access Experts' View on the 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 [...]
New Microsoft 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 [...]
Learn How to Performance Tune Microsoft 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://accessuse [...]
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 [...]
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 [...]
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 [...]
![[UPDATED 2] Critical: Office Update breaks Access -- Query is corrupt](https://accessexperts.com/wp-content/uploads/2019/11/Office-Update-breaks-Access-600x272.png)