Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Thanked 0 Times in 0 Posts

    delete relationships with code (Access 2000)

    Can i delete relationship with code?

    I have an automated function that sends four tables to a database. After that i perform append queries
    and thben i want to delete these tables but i cannot because of the relationships.
    The tables in question are
    customers- orders - orderdetails-products
    the tables which i send are:
    customers1- orders1 - orderdetails1-products1

    I want to delete the last tables namely :customers1- orders1 - orderdetails1-products1

    The tables are related as folows
    customerid in the tables orders has a primary key and is connected with the table orders with a customerid in the orders.
    and so on

    Is there any function called Delete Relationship that can do the job?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Sint Niklaas, Belgium
    Thanked 0 Times in 0 Posts

    Re: delete relationships with code (Access 2000)

    Have a look at this post. There is some code to delete a relationship.

Posting Permissions

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