Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    58

    Unanswered: synchronize Access with other db

    Dear members,

    Is there anyway to synchronize a Access db with an other database(not access).

    I explain: In avery department there is a Access db where employees can enter their details, number of worked hours, days worked weekly.

    But some employees choose to go on the website of the company to fill the form. In this case details are sent to the main db(not access) on the central server.

    The question is how to synchronize the 2 databses at the end of the week ?

    Can anyone put me on a good road map ?

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    well we need to know what the other db is

    1 .. Have you tried to ODBC to the other database

    if no

    can you export the other database in some sort of format then you could import in access.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Mar 2004
    Posts
    58
    thank you myle for your replay ,
    the other database is probably sql server database..can be also oracle db

    I need to know if there is any commande in Access to perfom in order to do it.

    Which info do I need to know in order to be able to do it?


    Thanks in advance

Posting Permissions

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