Selasa, 14 Desember 2021

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

�

�

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

�

�

Re: [MSAccessProfessionals] Backend issues

After all databases are closed, and I have one person open the  FE database a locking file shows up for the BE file.  The database open correctly.

When a second person attempts to open the FE database (and fails) it appears as if the locking file disappears.

When the second person tries to open the FE database again, it still fails.

I am now looking at BE file and there is no locking file showing.

 

Bill

 

Bill Singer

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Tuesday, December 14, 2021 10:50 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Backend issues

 

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

 

 

Re: [MSAccessProfessionals] Backend issues

adding onto what Duane said too! Users have to have permission, of course ... but with Windows Home, it can't be granted


On 12/14/2021 10:56 AM, crystal viii wrote:

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

�

�

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

�

�

Re: [MSAccessProfessionals] Backend issues

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

 

 

[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