[AccessD] Front End Updater

John W. Colby jwcolby at colbyconsulting.com
Thu May 12 19:57:49 CDT 2005


Simplicity.  My clients typically have 30-40 stations max, and the FE takes
a few seconds to load.  A batch file took about 3 minutes to cook up and
just works.  Obviously if this is going to a system with hundreds of
workstations then something else would be in order.  The other thing is that
by downloading a fresh copy every time they open the FE I can do temp tables
without worrying about bloat.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Thursday, May 12, 2005 8:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Front End Updater


I can't see either why you would want to download the FE every time. I
always do a check on startup and replace only if the version no. has
changed. Kath
  ----- Original Message ----- 
  From: Francisco Tapia 
  To: Access Developers discussion and problem solving 
  Sent: Friday, May 13, 2005 10:21 AM
  Subject: Re: [AccessD] Front End Updater


  That still sucks, the updater I put together checks the ver through the
day 
  (about once every hour), a small tiny file less than 1k, that's not a big 
  deal but if I was gonna incorporate wan, i'd slow the check to once on
boot 
  up of the software and once per day (if they never shut down). having to 
  dowload whatever the FE size is every time you wanna use the application 
  makes it feel clunky.

  On 5/12/05, John W. Colby <jwcolby at colbyconsulting.com> wrote:
  > 
  > On a local lan I just have a batch file that does the download every
time
  > the user loads the FE. Over a low speed wan this might be problematic,
  > though over a high speed internet connection it would probably work just
  > fine.
  > 
  > John W. Colby
  > www.ColbyConsulting.com <http://www.ColbyConsulting.com>
  > 
  > Contribute your unused CPU cycles to a good cause:
  > http://folding.stanford.edu/
  > 
  > -----Original Message-----
  > From: accessd-bounces at databaseadvisors.com
  > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
  > Sent: Thursday, May 12, 2005 2:52 PM
  > To: Access Developers discussion and problem solving
  > Subject: [AccessD] Front End Updater
  > 
  > I know that this has been kicked around several times in the past, but
  > I'd like to know the current thinking on this subject. Given N users on
  > a LAN (and it might be a WAN), we want to place any updates in one
  > standard place (probably using a hardcoded reference to the box and dir)
  > and then have a mechanism that checks to see if the update is more
  > recent than the version locally loaded.
  > 
  > What puzzles me about this is: given Access's habit of re-timestamping
  > the ADP/MDB file upon loading, how do you compare versions to see which
  > is more recent? A laptop user, for example, currently disconnected but
  > going to be connected tomorrow morning, may have a more recent timestamp
  > on her file than the one on the net. How do you get around this problem?
  > 
  > TIA,
  > Arthur
  > 
  > >
  > >
  > 
  > --
  > No virus found in this outgoing message.
  > Checked by AVG Anti-Virus.
  > Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 5/12/2005
  > 
  > --
  > 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
  > 



  -- 
  -Francisco
  http://pcthis.blogspot.com |PC news with out the jargon!
  http://sqlthis.blogspot.com | Tsql and More...
  -- 
  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






More information about the AccessD mailing list