Runtime Code

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DD
    #1

    Runtime Code

    Can someone advise if there is code that i should avoid when writing a
    database that will be packaged using Runtime.
    thanks in advance
    dd
    Tags: None
    • Allen Browne
      #2
      Re: Runtime Code

      Hi David

      It's not difficult, but some of the issues are:

      1. Don't use macros. If anything goes wrong, your application will close
      (which to the user looks like a crash) because macros have no error
      handling. Use error handling in every routine. If you need to use a macro,
      it should contain only the RunCode action, which passes control to a
      procedure that does have error handling.

      2. Don't try to open forms/reports in design view. That also means Filter By
      Form is not available. Using an MDE catches this anyway.

      3. If you code for different printers, PrtMip etc won't help.

      4. Use fonts that will be on the target system such as Arial and MS Sans
      Serif. Although it is possible to specify fonts in the installation package,
      doing so confuses users if the font is already on the target system (e.g.
      when they re-install).

      5. If you split (shared back end, local front end), be sure to included code
      that verifies the data file on start up. You may choose NOT to install the
      data file by default (i.e. user has to copy it to desired location) so that
      a) it does not get installed multiple times for different users, and b) it
      does not get overwritten in a re-install.

      --
      Allen Browne - Microsoft MVP. Perth, Western Australia.
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "DD" <david.deacon@b igpond.com.au> wrote in message
      news:1412655e.0 402291648.19a08 648@posting.goo gle.com...[color=blue]
      > Can someone advise if there is code that i should avoid when writing a
      > database that will be packaged using Runtime.
      > thanks in advance
      > dd[/color]


        Comment

        • Trevor Best
          #3
          Re: Runtime Code

          Allen Browne wrote:[color=blue]
          >
          > 5. If you split (shared back end, local front end), be sure to included code
          > that verifies the data file on start up. You may choose NOT to install the
          > data file by default (i.e. user has to copy it to desired location) so that
          > a) it does not get installed multiple times for different users, and b) it
          > does not get overwritten in a re-install.
          >[/color]

          One thing to consider is a separate install just for the tables rather
          than having the tables and/or code as an option as in most cases the
          installation will be mutually exclusive.

            Comment

            Previous template Next
            Working...