Access 2000 Create Multiple tables depending on a data field chang

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a table with multiple data records per person's name. I would like to
output a table each time the person's name changes. Example: if there are 6
records for Bob Smith, I want those 6 records output to a table named
xxxBobSmith. if there are 5 records for Sue Palmer, I want to output those 5
records to a table named xxxSuePalmer.
.