Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Backup SQL Tables in Microsoft Access 97

Options
  • 13-08-2004 12:47pm
    #1
    Philbert
    Registered Users Posts: 358 ✭✭


    Dear All.

    I have an Access 97 Database with about 50 ODBC linked tables to our web server. I want to run a program in this database which will backup all these SQL tables to local tables. This program would be run once a day and ideally it would only backup any information that has changed in the tables.

    Unfortunatley the "CopyObject" and "TransferDatabase" doesnt really work as it only creates new links to the existing linked tables. I have thought about using the make table sql in a For Loop which would go through each table and make a local copy of it. The problem with this is that I would have to create a unique make table sql statement for each table because I know of no way to include "all fields" in the sql statement without adding each field manually.
    Maybe there is a better way of doing this.

    Any help is very much appreciated.

    Thank you.


Advertisement