Re: [MSAccessProfessionals] Backend issues

Now that everyone is back from the holiday vacation I have had no complaints.   I will check with them to make sure.

 

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Mosca
Sent: Monday, January 10, 2022 3:06 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues

 

Bill-
I read somewhere that the latest patches fixed the "single user" bug in Access. And you weren't on a short list. It affected all users who had installed the buggy Office update. Once again, MS has made Office so complex that the slightest change in one piece can have terrible consequences and the amount of testing by MS corporate developers is never thorough.

 
--

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP 2010-2016

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

On Wed, Dec 15, 2021 at 05: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

�

�