I'm attempting to access a SQL database table vias a ODBC connection. I have created a dataset. From the Query window I can access the database and execute "List Objects" displaying the tables. When I Testrun the command (select * from tablename) I receive the message Microsoft ODBC SQL Server Driver SQL Server Invalid object name 'tablename'. I have tried several tablenames and receive the same message. I have Testrun the command (select name from sysobjects where typw=U' order by name) and it displays the tablenames. Does anyone have any ideas?

Thanks

Richard

View this thread on the Works forum...