Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: delete and create one to one relationship with VBA

    I have an MS Access db that contains two tables that are updated periodically through make table queries. Currently I have to manually delete the relationship between these tables before running the make table queries, then re-create it before running my final select query that gives me the data I'm looking for. I've had no success in trying to write some VBA code that will first break the relationship, kick off the two make table queries, then re-create the relationship. Can anyone help?

  2. #2
    Join Date
    Feb 2004
    Houston, Texas
    Have you looked for CreateRelation in the help? It's actually a pretty good example of how to get started.

Posting Permissions

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