>>>Hi All,
>>>
>>>I am running Mere Mortals but this exception is being thrown fromt he SqlAdapter.Fill method so shouldn't matter much.
>>>When adapter.Fill(ds, tableName); is called I am getting an exception of "Invalid object name dbo.CompanyAccess"
>>>
>>>I am not sure if this means the connection is not working or it can't find this table. The table does definately exist and I tried a different table access with the same result. What might cause this to happen?
>>>Tim
>>
>>Would have something to do with the database name changing between your local copy and the site? Maybe some of the generated SQL refers to the other server?
>
>
>The connection string has "Data Source=(local)". Is this a problem for running in the dev server; do I need to explicitly name the SQL server?
>Tim
It should only be a problem if there is more than once instance of SQL Server running.
Is "dbo" the actual owner of these tables?