This is causing a small inconvenience due to the holidays. Any guess on how long it takes for Microsoft to come up with fixes for these types of issues. Maybe I will just wait rather than try and roll back all the computers.
Bill
Bill Singer
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Wednesday, December 15, 2021 6:56 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues
The Access team is aware of this problem. For those affected by the latest patch adversely, here are instructions to rollback to an earlier version:
For MSI builds, see: Information about the ability to uninstall Office
��� https://docs.microsoft.com/office/troubleshoot/office/ability-to-uninstall-office
For Microsoft 365, see: How to revert to an earlier version of Office 2016 Click-to-Run
��� https://support.microsoft.com/help/2770432/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic
kind regards,
crystal
On 12/14/2021 3:50 PM, Graham Mandeno via groups.io wrote:
Hi Bill
It looks like the two Win 11 machines were updated overnight.
Does it make any difference if you open in on the Win 10 machine first?
- Graham
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Wednesday, 15 December 2021 08:25
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
Win 11 pro� Microsoft� Access� for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20204) 32-bit
Win 11 pro� Microsoft� Access� for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20240) 32-bit
Win 10 home� Microsoft� Access� for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20234) 32-bit
�
�
Bill
�
Bill Singer
�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Graham Mandeno via groups.io
Sent: Tuesday, December 14, 2021 1:08 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
Hi Bill
If this just started suddenly this morning then I would suspect an overnight update to MS Office (especially as it�s Tuesday!)
Can you please check what Access build each computer is running (File > Account > About Access).
You should see a page of information and licence guff, and up the top there is something like this:
Microsoft� Access� 2016 MSO (Version 2110 Build 16.0.14527.20234) 32-bitwhich you can right-click on and copy.
Please report back for all three computers.
Best wishes
Graham�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Wednesday, 15 December 2021 07:33
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
All computers have Access set to run in the �Shared� mode.
All users open the Access Database by opening Access first and then clicking on the most recent file.
�
I can copy the BE once all users close access.
�
�
Bill
�
Bill Singer
�
�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Tuesday, December 14, 2021 11:51 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
Bill � It could be that the first user is opening the� database in exclusive mode. That would block all other users. Open Access without opening any databases. Under File > Options> client settings>advanced: check that each user ha the default mode set to �Shared�
�
This has to be checked for all users. Also, how are they opening the database? If they are double-clicking it in the Windows Explorer, this action will automatically open the database in exclusive mode.
�
Regards,
Bill Mosca,
Founder, MS_Access_ProfessionalsMS Access MVP 2006-2016
My Nothing-to-do-with-Access blog�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Tuesday, December 14, 2021 9:34 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
Now I have also noticed that if I try and make a copy of the Backend file, it says it the action can�t be completed because the file is in use by another user.��
�
Bill
�
Bill Singer
�
From: bill.singer@at-group.net <bill.singer@at-group.net>
Sent: Tuesday, December 14, 2021 11:29 AM
To: 'MSAccessProfessionals@groups.io' <MSAccessProfessionals@groups.io>
Subject: RE: [MSAccessProfessionals] Backend issues�
Here are the 3 windows versions I have.
�
Microsoft Windows 11 pro.
Microsoft Windows 11 pro.
Microsoft Windows 10 home, has not been updated yet.
�
It appears as if everyone has the permission to create a file (Microsoft word) in the folder that the Backend is stored, and then delete the same folder.
�
�
�
�
�
Bill
�
�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Tuesday, December 14, 2021 10:57 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues�
hi Bill,
�
I've seen this problem when users have Windows HOME instead of a business version where more sharing and security is possible.
�
kind regards,
crystal�
On 12/14/2021 10:50 AM, Duane Hookom wrote:
Hi Bill,
�
Do you see the locking file in the folder containing the backend database file? Can all users create and delete files in the backend folder?
�
Regards,
Duane
�
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Bill Singer <Bill.Singer@at-group.net>
Sent: Tuesday, December 14, 2021 10:44 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Backend issues�
A strange thing happened this morning.
�
I have Windows 11 on 3 computers that all run Office 365 Access.
I have a Front end Access database running on all three computers and they all link to the one Backend database.� Never had a problem until this morning.� Now only one computer can access the backend database at a time.� Once it is opened on one computer, the other two can�t log in.
�
Any thoughts?
�
Bill
�
Bill Singer
Minnesota
�
�
Tidak ada komentar:
Posting Komentar