[AccessD] Multiple Frontend Users

Bob Heygood bheygood at abestsystems.com
Mon May 26 22:13:35 CDT 2008


Could we post this bat file on a web site?

Bob Heygood


 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Catherine
Blansett
Sent: Sunday, May 25, 2008 5:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Multiple Frontend Users

Chris, I would be interested in the Bat file.

Thanks

CB

catheirne.blansett at infocentraldata.org

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Foote, Chris
Sent: Tuesday, May 20, 2008 7:22 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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
> 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.523 / Virus Database: 269.23.21/1457 - Release Date: 5/20/2008
4:45 PM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.523 / Virus Database: 269.24.1/1465 - Release Date: 5/25/2008
1:22 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list