Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Backup SQL Tables in Microsoft Access 97

  • 13-08-2004 12:47PM
    #1
    Philbert
    Registered Users, Registered Users 2 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