Thanks to everyone for the replies. We found out that the table name was wrong. Once it was changed to the right database it worked. But everyone gave me other things to try if we run into this again.

Thanks,

David