[AccessD] Multiple Frontend Users

  I would also argue with them that in this case, the FE is more like a
program and it does not need to be backed up as it is not storing any data.
I'm sure they have many programs installed locally on each PC.

  John's point too about increased network traffic is an excellent one; I've
yet to meet a network engineer that likes to hear the words "increased
traffic"

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 20, 2008 8:06 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Multiple Frontend Users

There is no arguing with the Network Nazis, they own the network and 
what they say goes.  Never mind that it may cause YOU problems.

What you need to at least tell them in a place like that is that the FE 
is transferred to their PC daily.  It is backed up on the network store, 
the local hard drive just makes it faster because there is not so much 
NETWORK TRAFFIC.  Reducing network traffic MIGHT get their attention.

Unfortunately there may be cases where they have just locked the local 
store down and there is nothing you can do about it.  However... each 
user may then get their own NETWORK STORE and you could then transfer a 
copy to their individual network store location and run it from there?

Just things to think about.

John W. Colby
www.ColbyConsulting.com


Arthur Fuller wrote:
> I was presented with this problem recently and recommended this solution.
> The network support people flatly refused it. They argued that in their
> setup (with hundreds of users) virtually nothing on the local PCs was
backed
> up. The local PCs can be replaced and/re-imaged anytime, and users are
> warned not to store anything locally, otherwise it won't be backed up. So
I
> had no choice but to put both the FE and the BE on a network share. The
> argument makes perfect sense to me, but I've never done it that way
before.
> What will happen when a hundred users open a single FE? Should I replace
the
> FE MDB with an MDE?
> 
> Thanks,
> Arthur
> 
> On Mon, May 19, 2008 at 10:42 AM, Dan Waters <dwaters at usinternet.com>
wrote:
> 
>> Ed,
>>
>> Even with 3 users, splitting is a good preventive measure to avoid data
>> corruption.  You can put the Access Back End .mdb file on the server, and
>> put the Front end .mdb files on each user's PC.  Managing 3 users
shouldn't
>> be difficult.
>>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com