ACCESS FEED: Re: [MSAccessProfessionals] Backend issues

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-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
ï¿½
ï¿½

ACCESS FEED

Rabu, 15 Desember 2021

Re: [MSAccessProfessionals] Backend issues

Tidak ada komentar:

Posting Komentar