Thanks Si. The renaming is what I did to get it to run but you are correct, I do not have access to the original programmers who are still updating the database. I don't expect this project to last longer than this week (fingers crossed) so it is not a big issue here. I was just thinking about what happens in the future if I come across it.

I tried your idea

Code:
AccCMD.CommandText = "SELECT Accounts.[ID#],...
But it didn't work. I still get the same message. I tried other variations also. I am going to mark this one resolved at this point. Thanks for the answers. I tried to rate everyone but the forum wouldn't let me.