Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    update front end (XP/2K)

    I have a very large front end mdb. Is there a way that when I make small changes I can extract just those changes and be able to email only the changes in some way so they can be imported to the existing front end? Would creating a small mdb with just the changed forms reports etc. and then creating an export function that runs from that mdb work?
    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    Zave

    I am a bit confused by what you are trying to do. Can you explain a bit further?

    Jerry
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    Not without a lot of programming and a competent person on the other end to make the changes. How big is this "very large" front end? Your best bet would be to send them a CD with the updated front end on it. However, if you have allowed them into the front end to create queries, etc., you have just discovered the best reason not to do that. <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    Charlotte

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    It is not bigger than a CD obviously. But it is about 9 meg which is a bit much to email. But if it is too difficult (and there is NEVER someone competent on the other side) I will just have to send them CDs.
    Thanks

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    I wanted to be able to only send the changed parts and not an entire mdb.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    Zave

    If you have just made changes to, say a form, why not just export that form or object to a new database. The person at the other end, with a cleverly drafted email instruction tell them how to import that form or object into their database.

    Jerry
    Jerry

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: update front end (XP/2K)

    They would first need to delete the existing form, because the import does not overwrite the existing form, just adds a 1 to the end of the name. Obviously, I do not want to give the end users access to the database window to delete objects, so it would have to be through code. That is wherre it gets sticky as Charlotte pointed out

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

    Re: update front end (XP/2K)

    As has been pointed out, doing updates in these situations is complex. We always arbitrarily replace the entire front-end, and use a utility to do the version checking if a large number of users (>10 say) are involved. If a user needs to have the ability to create their own queries, we give them a separate database for just that purpose. The only other scheme we have used is replication - in that case you do get incremental design changes propagated to replicas, but there is substantial overhead as well as maintenance nightmares associated with replication.
    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
  •