Re: [MSAccessProfessionals] Backend issues

hi Bill,

you listed the Home version last ... if you installed it last, then features of previously installed versions may have been replaced ... Home versions cripple capabilities such as folder privileges that can be set for users and groups. An exception to this rule if is you want 64-bit and also 32-bit -- although I haven't done that myself, that's what I've heard.

> the file is in use by another user

users need permissions to Create and Delete the LACCDB file, and to share it. Home won't let you do that.

imo, it's best to install lower versions with less permissions first if you have a multiple version installation

kind regards,
crystal

On 12/14/2021 11:34 AM, Bill Singer wrote:

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

�

�