hidden relationships between tables

[SOS]

I tried to change a field size of a table but got error msg about the
relationships. I looked the relationships under the tools. I don't see any
relationships for this table. However, this table will store the result of an
append query. This append query use one table which has relationships with
other tables. But I already disconnect those relationships. I don't know what
can i do at this point. Is there anyway I can disconnect those hidden
relationship in the query? or tables?
Please help!
Thanks.

SOS

 

[Alex Dybenko]

Hi,
first you can run in immediate window:
?currentdb.Relations.Count

if it will return more then 0 - then you have some relations

open relationships window, click on a table and then click on "show all
relationships"

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com