[AccessD] Runtime Vs Full Access Install

Kath Pelletti KP at sdsonline.net
Wed Jul 27 21:24:48 CDT 2005


<<...runtimes won't solve version change problems.....
Really? 

Are you saying that if you distribute a runtime and users then install eg. a newer version of Access then it can play up? Sounds like a headache....exactly the kind of problem I have now.

Kath
  ----- Original Message ----- 
  From: William Hindman 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, July 28, 2005 11:34 AM
  Subject: Re: [AccessD] VBExpress videos


  ..pretty much the same way you do Kath but I make the changes on my 
  development system ...test it on my client simulator system ...and then put 
  a new fe on the network for normal update by the runtime systems.

  ..runtimes won't solve version change problems ...but you can build code 
  into your startup to check the current version and load the correct runtime 
  if you anticipate version changes ...that's a bit of work and only works 
  transparently if MS doesn't throw a monkey wrench into things ...the damn 
  "sandbox" in 2003 is a "*(&%$ example of such ...code runs fine in full 
  Access but errors all over the place in the runtime ...so far I've just 
  disabled it ...the "new" file dialog object is another example of something 
  that works fine in full mode and not at all in runtime :(

  William

  ----- Original Message ----- 
  From: "Kath Pelletti" <KP at sdsonline.net>
  To: "Access Developers discussion and problem solving" 
  <accessd at databaseadvisors.com>
  Sent: Tuesday, July 26, 2005 8:57 PM
  Subject: Re: [AccessD] VBExpress videos


  ..hhmmm....thinking over the pros and cons.....I am getting very tired of 
  clients changing office versions etc etc and having the app crash.

  And I am getting very sick of setting refs and finding that some users end 
  up with it missing - whoops - crash again. So runtime should solve both 
  those issues?

  On the other hand, with my main client (using full Access install) I can get 
  straight on to their PC online using VNC, make a change to the mdb, recreate 
  the mde and post it to the network from where it gets automatically 
  downloaded the next time all users open it.

  That would be much harder with runtime, wouldn't it? How do you distribute 
  upgrades?

  Kath
    ----- Original Message ----- 
    From: William Hindman
    To: Access Developers discussion and problem solving
    Sent: Monday, July 25, 2005 1:15 PM
    Subject: Re: [AccessD] VBExpress videos


    ..yes ...lessons learned the hard way ...give a client full Access and
    "things" happen ...bad things ..."upgrade" that client to the newest 
  version
    of Office Standard (w/runtime) rather than Office Pro and save them a lot 
  of
    money ...its amazing how many strange happenings stop happening to your 
  apps
    :(

    William

    ----- Original Message ----- 
    From: "Kath Pelletti" <KP at sdsonline.net>
    To: "Access Developers discussion and problem solving"
    <accessd at databaseadvisors.com>
    Sent: Sunday, July 24, 2005 7:58 PM
    Subject: Re: [AccessD] VBExpress videos


    <<how does anyone that actually supports distributed
    Access based apps get by without it? ...that would mean clients having 
  full
    Access installs and all the troubles that implies ...I'd rather starve 
  first

    William - does this mean that you ony distribute runtime apps?

    Kath
      ----- Original Message ----- 
      From: William Hindman
      To: Access Developers discussion and problem solving
      Sent: Friday, July 22, 2005 4:08 PM
      Subject: Re: [AccessD] VBExpress videos


      ..thanks JC, I'll dl the videos and have a look then ...tap dancing 
  around
      VB.net whenever I'm bored with everything else going on ...the VB name 
  is
      similar but the ide keeps throwing me for a loop and nothing ports
    cleanly,
      at least for me ...but I admit to getting old :)

      ..as for the VS Tools, how does anyone that actually supports 
  distributed
      Access based apps get by without it? ...that would mean clients having
    full
      Access installs and all the troubles that implies ...I'd rather starve
    first
      :(

      William

      ----- Original Message ----- 
      From: "John W. Colby" <jwcolby at colbyconsulting.com>
      To: "'Access Developers discussion and problem solving'"
      <accessd at databaseadvisors.com>
      Sent: Thursday, July 21, 2005 10:11 PM
      Subject: RE: [AccessD] VBExpress videos


      > William,
      >
      > Apparently Express is a simplified version of the one that comes in 
  the
      > Visual Studio.  As for the videos being useful, I think mostly yes. 
  The
      > videos are about how to manipulate the various windows, the controls,
    the
      > forms etc.  All that is pretty much just like the version in Visual
      > Studio.
      >
      > My email was aimed at those lost souls (like myself) who either have
    never
      > managed to really "get there" with Visual Studio, or never even
    purchased
      > it
      > because of the expense.  VBExpress is free (for the beta which is very
      > stable) and will be $50 when released at the end of the year.
      >
      > 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 William
    Hindman
      > Sent: Thursday, July 21, 2005 9:57 PM
      > To: Access Developers discussion and problem solving
      > Subject: Re: [AccessD] VBExpress videos
      >
      >
      > JC
      >
      > ..how is this different than the VB.Net that comes with Visual Studio
      > Tools? ...since MS compels me to pay for the standard version of 
  VB.net
    in
      > order to get the equivalent of the old ODE, why might I want to go the
      > VBExpress route instead?
      >
      > ..and are the videos of use in the VB.net ide?
      >
      > William
      >
      > ----- Original Message ----- 
      > From: "John W. Colby" <jwcolby at colbyconsulting.com>
      > To: "VBA" <dba-vb at databaseadvisors.com>; "AccessD"
      > <AccessD at databaseadvisors.com>
      > Sent: Thursday, July 21, 2005 2:50 PM
      > Subject: [AccessD] VBExpress videos
      >
      >
      >> In case you haven't found them, there is a beta available for
      >> VBExpress which is really just VB.Net light version, with its own IDE
      >> instead of being embedded in Visual Studio.  The IDE looks and feels
      >> almost identical to the
      >> Visual Studio however.
      >>
      >> http://lab.msdn.microsoft.com/express/beginner/
      >>
      >> Once you download and install the VBExpress notice the videos
      >> available.
      >> I
      >> discovered this guy a couple of years ago but he has now done (some)
      >> videos
      >> for this VBExpress and I am finding them very useful  I think they
    would
      >> allow anyone who frequents this board to get up to speed pretty
    quickly,
      >> and
      >> I have to tell you, VBExpress.net is waaay cool.  The videos will 
  show
      >> you
      >> how to do stuff in the user interface (all that I have gotten to so
    far)
      >> that we can only dream of in VBA.
      >>
      >> Check it out - it looks very good to me.  I am working through the
      >> video series right now.
      >>
      >> John W. Colby
      >> www.ColbyConsulting.com
      >>
      >> Contribute your unused CPU cycles to a good cause:
      >> http://folding.stanford.edu/
      >>
      >>
      >> --
      >> 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
      >
      >
      >
      > -- 
      > 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
    -- 
    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
  -- 
  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