Downloading backend files when others are connected

[robert d via AccessMonster.com]

My users are complaining about how slow the network is. I have different
user groups in my app and there is a user group that cannot update any
information in the tables. Individuals assigned to this group only want to
use the data and run complex analyses that can take several minutes even when
the front end and back end are on a local PC (tens of thousands of rows
across many tables along with calculations per row). When the backend for
these complex analyses is on the server, it really takes quite a long time.

I have a separate logon form where I've added an option to allow users to
download the backend files to their local PC. Before I get a lot of
responses about how stupid an idea this is, please remember that this
functionality is designed for users who have no ability to update data. They
simply use data, and yes, it is possible that someone might update the data
while these users work with the downloaded BE, but they understand that this
can happen (besides, in reality, data is typically only updated once or twice
a month).
I use the Cmd switch to pass the download request to my app, which has the
code to do this. My front-end will then automatically link to the downloaded
backends.

I've been testing this and everything works just fine. However on my small
network, if I have the "server" backend connected to a front-end on one
machine and then on another machine I try to download the backend file from
the server, I get Error #70 permission denied. I assume that I'm getting
this error because I am trying to FileCopy a backend file from the server
that is in use (I guess that means a .ldb file has been created).

I want to confirm that my understanding of why I'm getting this error is
correct.

Thanks.

 

[robert d via AccessMonster.com]

Well, now I'm not so sure I understand what is going on. I was just able to
FileCopy the "server BE file" even though another machine was connected to
the "server BE file".

HOWEVER, that other machine only had the "splash screen" displayed. No data
was actually accessed.

I retried this experiment where I first brought up a form that displayed data
on the front end connected directly to the server backend. Then I tried to
FileCopy the "server BE file" on the other machine and now I'm getting Err#70,
permission denied.