Relationships trouble

#1 (**permalink**) 28-Jul-2006, 08:38 AM

I have a DB (2000) with a number of tables, tableID being the one of interest. I
need to import a new tableID (it has added fields). I import it and get
tableID1. I need to rename tableID to say tableIDBAK, and rename the new one
from tableID1 to tableID. No problem until I try to delete tableIDBAK. Access
complains about a relation to another table, but when I look at the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13630-relationships-trouble.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
relationships, I don't see any. Is there a way to see that, so I can set the
relationship for the newly imported table?
Thanks,
Mike

*

#2 (**permalink**) 28-Jul-2006, 08:38 AM

Try right click/show all in the relationship view. Plus you can check
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
your objects dependences. To do this just right click on the table and
choose object dependences.

David

MikeR wrote:
> I have a DB (2000) with a number of tables, tableID being the one of interest. I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
> need to import a new tableID (it has added fields). I import it and get
> tableID1. I need to rename tableID to say tableIDBAK, and rename the new one
> from tableID1 to tableID. No problem until I try to delete tableIDBAK. Access
> complains about a relation to another table, but when I look at the
> relationships, I don't see any. Is there a way to see that, so I can set the
> relationship for the newly imported table?
> Thanks,
> Mike

#3 (**permalink**) 28-Jul-2006, 08:38 AM

Also the hidden table MSysRelationships holds all relationship info

Pieter

"gumby" wrote in message
news:1153418677.827826.281030@p79g2000cwp.googlegr oups.com...
> Try right click/show all in the relationship view. Plus you can check
> your objects dependences. To do this just right click on the table and
> choose object dependences.
>
> David
>
> MikeR wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
>> I have a DB (2000) with a number of tables, tableID being the one of
>> interest. I
>> need to import a new tableID (it has added fields). I import it and get
>> tableID1. I need to rename tableID to say tableIDBAK, and rename the new
>> one
>> from tableID1 to tableID. No problem until I try to delete tableIDBAK.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
>> Access
>> complains about a relation to another table, but when I look at the
>> relationships, I don't see any. Is there a way to see that, so I can set
>> the
>> relationship for the newly imported table?
>> Thanks,
>> Mike
>

#4 (**permalink**) 28-Jul-2006, 08:38 AM

Also the hidden table MSysRelationships holds all relationship info

Pieter

"gumby" wrote in message
news:1153418677.827826.281030@p79g2000cwp.googlegr oups.com...
> Try right click/show all in the relationship view. Plus you can check
> your objects dependences. To do this just right click on the table and
> choose object dependences.
>
> David
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
>
> MikeR wrote:
>> I have a DB (2000) with a number of tables, tableID being the one of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
>> interest. I
>> need to import a new tableID (it has added fields). I import it and get
>> tableID1. I need to rename tableID to say tableIDBAK, and rename the new
>> one
>> from tableID1 to tableID. No problem until I try to delete tableIDBAK.
>> Access
>> complains about a relation to another table, but when I look at the
>> relationships, I don't see any. Is there a way to see that, so I can set
>> the
>> relationship for the newly imported table?
>> Thanks,
>> Mike
>

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4285 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

#5 (**permalink**) 28-Jul-2006, 08:39 AM

Pieter Wijnen wrote:
> Also the hidden table MSysRelationships holds all relationship info
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
Thanks Pieter

#6 (**permalink**) 28-Jul-2006, 08:39 AM

Pieter Wijnen wrote:
> Also the hidden table MSysRelationships holds all relationship info
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13630
>
> Pieter
Thanks Pieter.