Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2003
    Location
    Gainesville, Florida, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Update table structure remotely (Access 2002 sp2)

    Subject edited by HansV to aid in future searches - "Access" was not very descriptive

    I have an existing application working in remote sites (non-networked) that require a change to a couple of the tables. Is there a way to alter the tables using another application? Basically I only need to add a field to a couple of tables. My only option I know right now is to retrieve those back end tables, modify them and send them back.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update table structure remotely (Access 2002 sp2)

    A commercial application that does that is Surgical Strike
    http://www.databasecreations.com/pro...icalstrike.htm

    A non-commercial application is Backend Updater
    http://www.databaseadvisors.com/downloads.htm

    or you can program your own right within Access using VBA and DAO.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  3. #3
    Lounger
    Join Date
    Mar 2003
    Location
    Gainesville, Florida, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Update table structure remotely (Access 2002 sp2)

    Thanks for your response. Charlotte, I realized the problems about referential integrity right after I posted my question. Jack, I will investigate the links you suggested.
    The problem with this small application is that is being used in many different sites. The client wants new information captured so somehow I must keep the original data in the tables in addition to the new fields. This would require me to travel to those sites and make the changes or have the different sites send me their *mdb files to modify and send back. One solution that I thought would work is to make a copy of the original backend which I have here , make the modifications to the tables and then just create a program that for each site moves the data from the tables to the new tables. Afterwards, the original frontend will link to the new backend. The original application already refreshes the links when opened. Thanks again.

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

    Re: Update table structure remotely (Access 2002 sp2)

    <P ID="edit" class=small>(Edited by charlotte on 01-Sep-05 17:41. corrected the results of brain operating at a different speed from fingers.)</P>What do you mean, "using another application"? You can certainly use code to modify them but if you want them to be able to use something on their machines to do it, I think you're asking for a disaster. You could, of course, send them a database that would use code to modify the tables in their current database. If there are relationships with referential integrity involved, you could even ship them a database with tables containing the additional fields and then just append the records from the existing tables to the new ones, but that will not work if you are enforcing referential integrity unless you take extreme care to append those records in the appropriate order to avoid running afoul of the referential integrity.
    Charlotte

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

    Re: Update table structure remotely (Access 2002 sp2)

    Actually, I just edited my post to say what I had meant to say instead of what I wrote! <img src=/S/blush.gif border=0 alt=blush width=15 height=15> The tricky part is appending the records to the empty tables in the correct order to avoid violating referential integrity.
    Charlotte

Posting Permissions

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