Post reply

Update a database

  • April 9, 2004 at 9:31 am

    #101954

    I'm not sure where to post this, so I apologize if there is a better category I should have selected.

    I would like to access one program from another. I have a commercial app with SQL 2k backend that has a scheduling routine I would like to use. I need any and all data entered by a user copied to our main DB, however, because our in-house custom app goes well beyond the capabilites of the scheduling program in question. That part I can handle by updating the main DB in response to an update on the mini DB.

    What I don't know how to do (or is possible) is how to update the mini DB from the main DB. I need to mimick user input to the commercial app (mini DB) so the two DBs are synchronized and I don't crash the commercial app. Does anyone ever do this?

    Thanks for your thoughts or comments!!

    SMK

  • April 9, 2004 at 10:30 am

    #502326

    replication may be the answer.

  • April 9, 2004 at 7:07 pm

    #502361

    Steve:

    Thanks. I am not stating my question clearly and it's a long shot, anyway. I think what I am after is automation. I want to run one program from another, basically simulating a user to the second app. I know this is frontend stuff, so maybe just direct me where I am more likely to get help with this.

    Thanks for your patience with a non-programmer type.

    And Happy Easter!!

    SMK

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply