Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting a User Version # (Access 2003)

    Can anyone tell me if there is a way to set a User Version number into an Access database so a Novell-delivered Application can tell if the version on the Lan has changed and then deploy the new copy to the user desktop when opened. Currently it checks the modified fields (Lan to user copy) and if different a new copy is made to the users machine. The problem is that each time the user uses his/her copy the modified field is changed and a new copy is delivered every time they open the database. This is fine for small applications but but we have two that take a while to download.

    Thank you
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

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

    Re: Setting a User Version # (Access 2003)

    You should probably be checking to see if a later version exists on the LAN rather than if they are different. But even that can have issues if you want to replace something in the middle of the day. We use a custom system we developed to check for versions and other issues, but the basic concept is to check the version of the database in a table. You can find out a bit about what we've done on our web site, and you might also look at the Startup Tool that FMS sells.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting a User Version # (Access 2003)

    Thank you Wendell. I'll take a look at both.
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

Posting Permissions

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