Thread: Liking Tables

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    West Midlands, U.K.
    Posts
    47
    Rep Power
    11

    Liking Tables


    Hi,

    I have two tables in a MS Access DB. One set of tables are being pulled down from the web and the other set of tables are the office.

    I want for all the web data to be put into the offline DB when refreshing etc.

    Is there anyway I can link the two tables so that on refresh, the web data is inputted into the office DB?

    Many thanks,

    Janusz
    http://www.xlibris.co.uk
    http://janusz.monkey-it.co.uk
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    West Midlands, U.K.
    Posts
    47
    Rep Power
    11

    Help!


    I'll explain a bit better!

    I have a DB. There are 3 tables. I have an online MySQL DB which I also use. I imported these via an ODBC connection and so have 6 DBs:

    Office_1
    Office_2
    Office_3

    Web_1
    Web_2
    Web_3

    How can I link Office_1 to Web_1 so that ALL the contents of Web_1 are imported into Office_1 on a refresh etc. Same applies to others.

    Many thanks,

    Janusz
    http://www.xlibris.co.uk
    http://janusz.monkey-it.co.uk

IMN logo majestic logo threadwatch logo seochat tools logo