Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Revising FE (2000/03)

    Hello once again. I'm about to launch an application for tracking training requirements. For the most part I'm quite happy with the result; data BE & 2 FE (one for data entry & the other purely for reporting).

    Now I can see that before 3 months are gone, there'll be assorted requests for additional reports, graphs, etc. This, of course, will necessitate changes to the FEs. So before this goes live, I'd like to build in some code, whereby when the application opens, it checks a specified location folder for any newer models, then overwrites the copy on the local drive.

    I have heard of this, and with my VBA still in the kindergarten stage this is clearly beyond my capabilities. If anyone could help me out, you'd make me a very happy bunny <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Revising FE (2000/03)

    Code in the frontend database will not work, probably, since you won't be able to overwrite the open frontend.

    You could use the method described by Mark Liquorman in the second half of <post#=483,813>post 483,813</post: >. This ensures that the user will always have the latest version of the frontend, and you don't need any VBA code.

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Revising FE (2000/03)

    Thanks once again Hans. Once I read that, there was one of theose "of course" moments.
    Cheers

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Revising FE (2000/03)

    You don't indicate how many users you will have that have the front-end on their local workstation (a very desirable practice by the way). If it gets to be a sizeable number, then Marks process - used by lots of people BTW - does tend to put a bigger load on the LAN in early morning in a typical environment. Another issue to be aware of is that users have to restart their PC to get the newest version - that can be a pain if there are lots of users or they are some distance apart. Working with a secured database is also more complicated - we normally deploy the security file as well as we've seen cases where a central security file goes corrupt and blocks all users. Hopefully none of these apply to you - if they do there are commercial applications that can help you deal with it.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •