Trouble with Relationships

[NJudson]

I'm running Access 2k and I built a database and did not set up any relationships to begin with. I got vba code and queries working for my program and one day I was messing around with the relationships window trying to learn how to set up relationships and I hosed things up. The problem I'm having is that in my code I'm running a couple Make-Table queries using the DoCmd.OpenQuery method and the table the query is supposed to delete and then write to was set up with relationships in the relationship window and the query crashed. This happened for both queries.

I went into relationship window and removed all the tables but the queries still crash when I run the code. Is their another instance of the relationships other than the relationship window. I selected in the Tools-Options menu to show hidden and system objects and was looking at those but don't really know what they are and don't want to mess things up worse without seeking help. This clueless man appreciates any help anyone can offer.
Thanks.

 

[NJudson]

I found this link on this site and was wondering if this is what I need to do to clear all the relationships in my database? Sounds like it but wanted to check to be sure. Thanks.

http://www.access-programmers.co.uk...?s=&threadid=6115&highlight=msysrelationships

 

[NJudson]

Thank you very much for your reply. It seems to have worked in removing the relationships, although I inadvertently deleted some tables that I wanted but that's ok because I just copied the tables over from the backup database I made before removing the relationships from the original database. Thanks again. All is good in my world....at least until my next progamming/database problem. Thanks again!