>>>>>Is "dbo" the actual owner of these tables?
>>>>
>>>>Apparently, as when I look in Sql Server Management studio they are listed as dbo.CompanyAccess. I just changed my login credentials to use the sa account but still no change. also I rechecked to make sure the BLG can access the tables and it works fine. I wonder if this is an MM issue.
>>>>Tim
>>>
>>>Try doing a search of your project to see if the database name got embedded someplace you weren't expecting.
>>
>>Nothing in any of the projects for WCF Server or clients other than the commented out connection strings in Web.Config or app.config
>
>One other idea (it won't fix it, but it might at least let you know if this is the issue). Try changing your SQL code to specify the full table reference, eg. SELECT ... FROM DatabaseName.dbo.CompanyAccess

I changed it to reference as PacSupport.dbo.CompanyAccess and there was no change. Interesting tho the message is still "Invalid object name dbo.CompanyAccess". I thought it might be "Invalid object name dbo.PacSupport.dbo.CompanyAccess". Kevin must be getting it strictly from the bizObj.table name property. Hmmm.. What would happen if I changed it there? I'll try.
Tim