hey andyahoo,
you can drop tables by going to phpmyadmin in your host cpanel and find the database called jos_comprofiler. there should be a link that allows you to drop the tables.. but this deletes all your cb data so be forewarned. what i found was that uninstalling cb and reinstalling did not solve the problem b/c the database tables are still in tact and reinstalling just uses the old tables you already had.. so when you "drop" the tables, it gives you a clean slate of new tables.. but on the otherhand, your data will be lost.. to prevent this i synced all users before uninstalling and when i reinstalled the new cb, i synced users again and it brought up the users from the joomla users (jos_users i believe). after, you'll have to manually add the cb fields that are not part of the joomla fields though. it worked for me but i don't know if it will work all the time and like i mentioned before, this is probably some really rudimentary and round-about way of doing things.. i hope that helps and i hope everything works out.