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

 

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

 

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

�

�