New current channel issue with Microsoft Access

Yet another bug introduced with January's current channel update, that sadly affects many Access databases. Microsoft is still working on an official bug page. Until then you can follow this post https://techcommunity.microsoft.com/t5/access/access-doesn-t-close-properly-a-remaining-background-process-can/m-p/3103807 which someone will ultimately provide the official link to. The bug appears to have been introduced by the VBA team which is separate than the Access team. There are other possible errors you will see including "Cannot Open any more databases". The good news is that if your database does not use VBA it will likely not be affected. The work around is to make the location of your database (you should do this for BOTH front and back ends if your back end is a Access database) a Trusted Location. Note that you need to do this on every computer running the application. If you have a large user base, there are ways to do this through the registry and through Office management as well. Below I have detailed the single user directions.

  1. Determine the path to your database file(s).?Do the below steps for each.
  2. Go to File – Options – Trust Center.

No alt text provided for this image
No alt text provided for this image

3. Click the Trust Center Settings button, then select Trusted Locations

No alt text provided for this image

4. If your path is on the network, make sure that the "Allow Trusted Locations on my network (not recommended)" checkbox is selected. If not select it.

No alt text provided for this image

5. Use the Add new location button

6. Put the path (include the / at the end) in the Path section at the top, click OK

No alt text provided for this image

7. Select OK

8. Close your database and reopen.


Joe Anderson

Database Architect at Southern California Edison

3 年

Keep on rockin' Maria :-)

Robert Barden

Accounting Software Professional

3 年

This is the second time that you have saved my hide by alerting us to the Microsoft bugs in their updates. Very much appreciate your diligence and generosity Maria!

要查看或添加评论,请登录

Maria Barnes的更多文章

  • Maximizing Efficiency and Innovation through Software Integration

    Maximizing Efficiency and Innovation through Software Integration

    Introduction In today’s fast-paced digital landscape, businesses and organizations are increasingly reliant on various…

  • Choosing the right platform for your application

    Choosing the right platform for your application

    You know that you want to make better use of technology to improve a business process. Congratulations! Recognizing…

    1 条评论
  • AI at Work Is Here. Now Comes the Hard Part

    AI at Work Is Here. Now Comes the Hard Part

    Earlier this month Microsoft and LinkedIn published a joint 2024 Work Trend Index Annual Report. The findings show that…

    5 条评论
  • Simplify Your Work with Templates in Power Apps for Teams

    Simplify Your Work with Templates in Power Apps for Teams

    In today’s fast-paced work environment, efficiency is key. Businesses are constantly seeking ways to streamline…

  • Should you move your data to the Cloud?

    Should you move your data to the Cloud?

    Benefits of Moving your data to the Cloud Moving your data to the cloud can offer several benefits, such as Scalability…

  • What is Microsoft 365 Copilot?

    What is Microsoft 365 Copilot?

    Why consider using Microsoft 365 Copilot? Enhance your productivity Ease digital overload – make use of powerful large…

    1 条评论
  • Responsible AI in the Age of Innovation

    Responsible AI in the Age of Innovation

    Introduction Artificial Intelligence (AI) has rapidly evolved from a promising concept into a transformative force that…

  • Unveiling Microsoft Q&A Assist: Your Gateway to Seamless Problem-Solving

    Unveiling Microsoft Q&A Assist: Your Gateway to Seamless Problem-Solving

    In the dynamic realm of technology, constant learning and adaptation are key to staying ahead. Microsoft, a pioneer in…

  • Bringing Law and Order to AI

    Bringing Law and Order to AI

    The European Union again made headlines a couple of weeks ago when its MEPs approved a modified version of the EU AI…

  • How AI can change the way we work

    How AI can change the way we work

    Much of the artificial intelligence (AI) we have seen prior to this year has been on autopilot. Think about how you may…

    2 条评论

社区洞察

其他会员也浏览了