design change with data already input

[lynn atkinson]

I have discovered a 'design fault' in my database which I think can easily be
recified. However, it means changing a relationship between some tables. Can
I do this in the existing database? It allows me to change the relationship,
but not to enforce ref integrity etc. If I create a new database with the
correct relationships between tables, can someone remind me of how to inport
just the data in to the empty tables.
I am sure this is straight forward, but my brain has just stopped working
this afternoon!
Any help would be appreciated.

cheers

 

[Tim Ferguson]

However, it means changing a relationship between some tables. Can
I do this in the existing database? It allows me to change the
relationship, but not to enforce ref integrity etc.

You can certainly enforce new relationships, but only if the rules are
currently being kept. For example, you cannot have any CDs linked to
Artists that don't exist, etc. You may need to go through your data and
clean them first. There are some wizard queries to find non-matching links;
post back here if you can't make them work.

If I create a new
database with the correct relationships between tables, can someone
remind me of how to inport just the data in to the empty tables.

If your old tables include illegal values, then you won't actually get any
further than you are now because the affected records will fail.

All the best


Tim F