[AccessD] Multiple Frontend Users

Tina Norris Fields tinanfields at torchlake.com
Sun Jun 22 14:46:17 CDT 2008


Chris,

I'm late getting to this thread, but I know I'm going to need your Bat 
file in the not too distant future.  So, here's another "me too."

Tina

Webadmin - Tenbus wrote:
> 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