[AccessD] Runtime Vs Full Access Install

William Hindman dejpolsys at hotmail.com
Thu Jul 28 00:26:29 CDT 2005


..hhhmmm ...either I'm misreading you or there is a fundamental 
misunderstanding somewhere in here ...a runtime mdb/mde is exactly the same 
as a full install mdb/mde ...the difference is that Access itself is not 
fully installed in a runtime ...the design/coding elements are not there so 
a user can't change anything ...it runs exactly as you designed it to run.

..if you have an A97 mdb and an A2k runtime it should still run as long as 
the references are there ...but the reverse is not true ...so I use startup 
code to check the installed version and call the corresponding fe mdb/mde.

..if you invest in the wise install tools, they handle those issues much 
better than the native Access distribution tools do and the default is to 
let them do all the work for you.

William

----- Original Message ----- 
From: "Kath Pelletti" <KP at sdsonline.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, July 27, 2005 10:24 PM
Subject: [AccessD] Runtime Vs Full Access Install


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