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

�

�