Deleting Relationships

[Hookstrat]

Is it possible to clear all existing relationships?! My database underwent some design changes and I am trying to change the data type of a field from text to number. However, Access 2000 will not let me change the data type without deleting existing relationships. Deleting the realationship and then saving the relationship window does not allow me to change the type either. I have used show all and everything else I can think of to fix the problem. I tried deleting ALL of my relationships and that still didn't help. Do I have to start my database completely over?!! I would really appreciate any help in this matter.
Sincerely,
Luke Hoekstra

 

[DonQuichote]

Are there any relationships left in a linked database (so-called inherited relations) or in the relationships collection? (In access '97 it was called CurrentDB.Relations, but I don't know what it's called in Access '0). If they are there, you might be able to delete them from code.

Good luck

 

[Hookstrat]

Thanks for the response, I can't find any inherited relations or relationship collection. Thank you for trying though.
Luke Hoekstra