[AccessD] Multiple Frontend Users

Webadmin - Tenbus spike at tenbus.co.uk
Mon May 26 22:47:46 CDT 2008


Of course!

I've had several "me toos" over the weekend - I'm sorry I've not 
responded as yet - quite busy ATM.

I'll put together something in the next couple of days and post it to 
the list (in the first instance).

Regards and thanks for the interest.
Chris Foote


 Bob Heygood wrote:
> 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