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?