[AccessD] Multiple Frontend Users

Arthur!

I've had similar arguments with our IT "professionals"!

My multi-user split FE/BE database worked as follows:

BE and copy of FE stored on network "share" along with bat file.
User has shortcut to bat file on desktop
When user needs to use database they double-click on shortcut to bat file.
Bat file looks to see if user has latest version of FE on their C: drive,
if not, it copies file for network share and runs it, if it is latest it
runs it.

Simple!

The only this you need to do if user gets a new machine is to create the
shortcut to the bat file. I would have automated that if I could have been
bothered ;-)

If you need any more info of a copy to my super-duper bat file please let me
know.

Regards
Chris Foote


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of 
> Arthur Fuller
> Sent: Tuesday, May 20, 2008 12:53 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Multiple Frontend Users
> 
> 
> 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
>