General discussion

  • Creator
    Topic
  • #2297146

    Yet again another Access Question!

    Locked

    by makita ·

    OK! I have a database (which is made up of many tables) on a laptop using Access 2002 which a coworker updates while out on the road. On Monday when he returns to work I want him to push a button and the data transfers to my database on my computer. He has a standalone on his laptop and I have standalone application on my desktop. How can I go about doing this? Can this be done?

All Comments

  • Author
    Replies
    • #2685306

      Reply To: Yet again another Access Question!

      by joseph moore ·

      In reply to Yet again another Access Question!

      Yeah, that could be done. You could write an Update Query in Access on the users copy that writes his data (in his tables) that connects to your Access DB using an ODBC connection. The Update Query would just copy each local table in his DB and write via ODBC to the remote tables on your DB copy.
      You could embed this query into a button in his Access DB copy.
      It is very possible. It is a little involved and tough to explain in a forum as this, but yes, very possible.

    • #2685244

      Reply To: Yet again another Access Question!

      by pnakiet ·

      In reply to Yet again another Access Question!

      I think you should use REPLICATION that is a tool in all MS Access version to make it done. With this tool, you could synchronize many database data at the same time any times you want data compounded.
      Refer to MS Access help for using it.

      Have success,
      PNAKiet

    • #2685186

      Reply To: Yet again another Access Question!

      by makita ·

      In reply to Yet again another Access Question!

      This question was closed by the author

Viewing 2 reply threads