Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating live database with changes (2003)

    I've started to update some database that I created in earlier versions of Access, and I've noticed that it's difficult to make changes to table stcuctres and forms if someone else has something open. So, I made a copy of the database for my own development, and have been periodically exporting the changes into the production databases.

    As I am the only developer, and currently each project tends to only have one or two users, this seems to be the simplest method right now.

    But I have two isssues that I'd apreciate advice on:

    1. How can I export changes to the structure of tables to other tables without altering the data. Actually, I kind of think tat even if I had a tool like this, I would be wary of using it. So, if I do the changes manually, is there a good way to get a list of all table and field properties, so I at least have something to check against?

    2. I suspect that what I am really doing by having two databases is creating a fork in the project. Even if I'm careful, I'm sure that changes will creep into either database that won't get replicated properly and pretty soon, I won't be able to update one from the other.
    I don't have a licensed copy of SourceSafe, and I think it might be overkill in any case. Is there another method that I could look into?

    Thanks for any advice.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Updating live database with changes (2003)

    " is there a good way to get a list of all table and field properties". This part I can answer.

    Use the Documenter: Tools...Analyse...Documenter Choose all the tables, and select the options you want listed.


    You might find this interesting as well. <A target="_blank" HREF="http://www.smartaccessnewsletter.com/ME2/Audiences/dirmod.asp?sid=&nm=&type=Publishing&mod=Publicatio ns::Article&mid=8F3A7027421841978F18BE895F87F791&A udID=C01C1922F71E483AB162D148B15A6F6D&tier=4&id=15 6A7C78030B4F49A6501CDE957095E4">Remote Updates of a Back-End Database
    </A>
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating live database with changes (2003)

    Thanks! The documenter seems to be something that I can use.

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Updating live database with changes (2003)

    You might want to check my website (see below) for my Documentor2000 utility. It tends to use alot less paper than the internal Access documentor, as you can pick and choose what you want to include on the report.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating live database with changes (2003)

    Great Thanks!

    I'm sure this will help a lot.

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating live database with changes (2003)

    Check out this little how-to article, it might help you synchronize your databases. I'm going to institute some of it in mine soon. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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