Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111

    Unanswered: Update a back-end

    This is the first time I'm thinking in this problem.

    I have a distributed .mde and its back-end needs to be updated: there is a table that needs to be changed -> 3 more fields.

    There are people that already has data in this table.

    How can I make this without loss of data?

    If someone has an idea I'll appreciate very much. Thank you.

    Regards,

    José

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    throw all users out of the DB
    backup the backend
    open up the backend
    add the fields

    adding fields to a table doesn't kill existing data (but don't forget that backup!).

    you might have to take a multi-step approach if you have unique-index or required on your new fields: don't set unique/required to start with; add the new fields; use UPDATE sql to populate wannabe unique/required new fields; then set the unique/required properties.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    Another information that is missing: the back-end is not in the same office. I cann't control it.

    I need to distribute an updated version that adds the new 3 fields to a table and preserve the user data.

    I don't know if my explanation is now a little bit clear, as I can't see how your suggestion - that I appreciated very much - can do the job.

    Thank you.

    José

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Can you get a copy of the current backend?

    If not, you would probably be best off writing a procedure to do this automatically, then have whoever is in charge of admining the current backend drop the code in as a module and run it.

    Obviously the ideal scenario is to get a current copy, run the updates yourself, then shoot it back, preferably during non-business hours so there's no data-loss.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    I just came across this today. Sorry to post a link to another forum, but I think this is what you're looking for:

    http://www.access-programmers.co.uk/...ad.php?t=75795

  6. #6
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    My God! Sorry for the link? Oh no! All is there.

    That's a BIG help and this subject is neither simple nor very usual.

    Thank you very much for all help and particulary this one.

    Regards,

    José

  7. #7
    Join Date
    Sep 2003
    Location
    MN US
    Posts
    313
    Great, glad it worked out. I just happened to be looking for the same thing this morning. I'd much prefer to go Teddy's route, but I think this will work in a pinch.

    I was apologizing because it's probably bad etiquette to send someone to another db forum. Not really sure. All's well that ends well, I s'pose.

    - Chris

Posting Permissions

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