Just so you know, I went through hell getting R2 installed. It wouldn't upgrade from 2008 to 2008 R2 something about features not upgradable.
I then tried to remove all of 2008 and reinstall R2 but it said I had to give it an 'instance' which after two tries I did and it installed but apparently 2008 was not gone. When I tried to log on it kept going to the older version. Then I had to find out how to put the instance on the logon and finally got that working on the management studio but still can't get the logon to work through my VB code.
Anyway, SQL seems very difficult to work with. Not intuitive like most MS products. The defaults on the install didn't all work either especially since I couldn't get rid of the older version. I really didn't want multiple instances on my notebook but at least now I can work on the tables and the database, now if I could just logon with my VB Code I could actually do some work after loosing 3 days.
Thanks for all your help. I really appreciate it.