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 >> >> >> > > >