Richard,

I know this is not news to you but I discovered that when I went to write some of the SQL statements ( I don't remember which ones exactly now) I got an error that had to do with the default library set in Access 2010 (which I use).  I had to reset the library back to DAO 3.x to get the code to work without error.  Shouldn't the new libraries funtion with SQL seamlessly or did I perhaps do something incorrectly?  This issue went away when I put the DAO Library ahead of the ActiveX....

Thanks for you help as always.