Redesign???

[NC_Sue]

As a newbie, I designed a database that I use daily at work. The people in
the database may belong to one of several "programs", and the "programs" may
contain any number of people (or none while in the development stage).
Unfortunately when I designed the original database, I knew nothing about
many-to-many relationships, so I have more peope than I should, i.e. I may
have one person entered 5 times as he belongs to 5 "programs".

Now that I know better, I'd like to redesign the database properly. But I
have about 900 people and 180 programs. What's the easiest way to fix this
without manually entering the whole shebang?

Thanks so much!

 

[Douglas J. Steele]

It's usually possible to write Append queries that will take the existing
data and write it to the appropriate tables.

Without knowing more about your old and new designs, though, that's about as
specific as I can get!

 

[Martin Fishlock]

Firstly make a copy of your database and use the copy and if you like it do
it on the real one.

You can try the Tools|Analyze|Table. I have not tried it but it may work.

The other way is to make the table that you want to hold your 1 to many
relationships creat the unique keys then insert columns into the destination
tables and add the keys. then delete the destination redundent columns.

You just have to be careful about duplicate names like Jane Smith or Bill
Smith and also misspelt names.

Happy checking...

 

[Jeff Boyce]

I'm with Douglas... unless you post your actual data table structure, and
maybe an example of data or two, it will be tough to offer any specific
suggestions...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/