Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Birmingham, UK

    Question Unanswered: Export linked backend tables to new database


    I have a split database where the users need to be able to trigger an export of of all data to a new unsecured database.

    My first thought was to use the 'docmd.transferdatabase' this works but exports linked tables to the new database as it is exporting the tables exactly as they appear in the front end.

    Does any one have any ideas about a neat way to do this, I had thought that it should be possible using workspaces to open a copy of the backend directly but 'docmd' is not avaliable this way.

    Any ideas please...

  2. #2
    Join Date
    Jun 2004
    Florida, US
    I guess you could design a make table query and run it in your code with a docmd method.

Posting Permissions

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