Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy relationships (Access 2000)

    In my work i often do copy all the objects of the database to a new database.Can i also copy the relationships instead of creating them anew? Is there a command in Access to copy all the relationships ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy relationships (Access 2000)

    The best way to do this is from the new database: select File | Get External Data | Import...
    Browse to the database containing the tables etc. and click Import.
    Select all the database objects you need.
    By default, Access will import the relationships between the tables. To check, click Options>>
    There is a check box to specify whether relationships should be imported. See screenshot below.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2005
    Location
    Plovdiv
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy relationships (Access 2000)

    Thank you for your reply. In the line
    DoCmd.TransferDatabase acLink, "Microsoft Access", Mypath, acTable, "table1", "table1"
    Is there a way to specify that i want to import the relationships too?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy relationships (Access 2000)

    No, because a relationship is between two tables, so it only makes sense to import relationships if you import several tables at once. If you only import one table, whether through the menu or using VBA code, importing relationships is meaningless, so it is impossible.

Posting Permissions

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