Recent Discussions
Access and SharePoint Integration May Be Broken
I am posting this here in the hopes that a Microsoft MVP or employee may see it, verify the issue, and report it to the right people at Microsoft. We have a fairly significant LOB application with the front-end hosted in Access and the back-end hosted in SharePoint Online lists. This application has been working well for several years. Sometime in the past few weeks (last known good date was June 23), a change in either Access or SharePoint (or maybe the Windows OneDrive sync client) seems to have broken integration between the products. When the modern cache format is enabled (the default), all SharePoint calculated columns unexpectedly show errors, as shown here (in a fresh database where I imported just one list from our site as a test): Naturally, this completely borks the application, with VB code throwing errors at startup. Using the legacy cache format, or disabling caching altogether, seems to restore functionality--(though this would come at a cost to performance): But there is a major caveat to this. Other functionality is apparently broken. We have straightforward update queries, for example, the hang indefinitely in these modes, rendering this an unacceptable work-around. I have been able to replicate this on several different PCs. Also, on several different SharePoint sites in our tenant. Currently, this is blocking work for us, and we are hoping to see it resolved as soon as possible. If anyone with knowledge of the right people at Microsoft to call attention to this, we would be grateful for any help. I am using the Access forum because the last time I tried to get help from SharePoint Online support for an Access-related query issue using SP list data, they had no idea what I was talking about. (Also, for Access database experts: please do not suggest that we avoid using calculated columns in SharePoint lists. This is a hybrid app with most of our users working with data strictly through SharePoint, and SharePoint views do not support the same features as queries do in Access. Making use of these SharePoint features are essential for these users.) Our Access version: Microsoft® Access® for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20124) 64-bit Thank you in advance for any help.New Entra ID group device criteria scoping is missing from Cloud Update
Hi, the New Entra ID group device criteria scoping is missing from Cloud Update. Message center says that it should be GA late July, but here we are and it's still not there. Is there a way to know when should we expect it to rollout for real? Thks in advance and don't hesitate if you have any questions
Access Query Problem
Good afternoon. I have been trying to track down a very strange error that my database has thrown for the first time ever... the query performs a complex math equation based on temperature, chlorine residual and pH time to compute the amount of time required to meet disinfection. This month the temerpature of the water has been historically high and the time required historically low. See the screenshot below. The math is evaluating the time required is greater than the time achieved (which it is not). The query is pasted below. I have recreated the math in excel and cannot duplicate this error. It seems exclusive to Access. When the formula evaluates as 10.0 the results are “YES” if the formula evaluates as 9.9 the result becomes “NO” but should be yes… Any advice would be greatly appreciated. Also, this post keeps getting flagged as SPAM... This is attempt number 5.. Fingers crossed.
Compute elapsed time
I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to account for the minutes where the start time minute is greater than the end time minute. Unless someone has another way of computing this.Contest Scoring
I created a spreadsheet to calculate points for a Skillathon test we give to kids at our fair. On the main sheet, we input the points earned for each question. I created a second sheet to calculate the points for question 20. I have a table set up to auto-sort the teams by Amount. I want to be able to take the points from this table and have that input into the main score sheet. Need help with the function for this.Copy a formual, locking 1 data cell
Hello I have this formual to calculate the value in cell F11. I woul like to copy the formula down to F12, 13, 14, 15 and 16. Needing to lock the cell F5 value in the formula. Copy and paste only changes for F% to F6 to F& and so on. Thank you =(D11-(B11+F5)-(G11)+C11)/D11
Recent Blogs
- You can now share direct cloud links to specific locations within a document in Word for Windows and for Mac.Aug 13, 2026
- A popular feature on desktop and the web is now available in PowerPoint for iPad: the ability to co-create with Microsoft 365 Copilot directly in your presentation.Aug 13, 2026
