design change with data already input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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.
Click to expand...

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
 
Back
Top