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 30 Times in 30 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,644
    Thanks
    3
    Thanked 65 Times in 64 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
  •