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-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-bit

which 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_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

�

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

�

�