Sent: Thursday, December 16, 2021 7:53 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>; Bill Singer <Bill.Singer@at-group.net>
Subject: Re :Re: [MSAccessProfessionals] Backend issues
I would like to add these few words. It would also be preferable to put the file we are using on the desktop. This way the user will not need to open Microsoft Access. Besides, I deleted the shortcut that there is in Microsoft Office.
Vladimir Laurent Le mer., déc. 15, 2021 à 2:37 PM, Bill Singer<Bill.Singer@at-group.net> a écrit:Great, I am on the short list. Why cant I be on the short list when they are talking about lottery winners. Hmmm
Right, with the upcoming vacations I will be OK for a while. I am not going to roll back unless I have to and at this point I do not have to.
Thanks for the update.
Bill
Bill Singer
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Wednesday, December 15, 2021 1:34 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues
hi Bill,
only a small number of users were affected -- you're on a short list ;) -- the good news is that it won't happen again. For now, current solution seems to be to revert back a version. In addition to the somewhat hieroglyphic way presented in the links, there seems to be a more direct way to specify desired version of Office with a batch file. If interested, ask.
> holidays ... how long it takes
problems rarely happen conveniently ... but on a positive note, not as much actually happens ~ and it will soon be fixed. My understanding is that Patch Tuesday in January will be fine, if not sooner for some
kind regards,
crystal
On 12/15/2021 7:36 AM, Bill Singer wrote:
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-officeFor 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-clickind regards,
crystalOn 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
�
�
