ODBC - call failedgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
We have converted an Access Database to SQL2000 database. When we go into Access and try to open the table, we get the following error: ODBC SQL Server Driver Select permission denied on oject 'database name'. database ICTEC over 'dbo'.(#229)
We have setup the ODBC driver correctly, and have given it the proper permissions.
We can go into the SQL database and access the table with no problem.
Thank you for your help.
-- Anonymous, December 02, 2004
Sorry for the delay. My computer was in the shop getting an upgrade.
All wisdom I can find on this indicates that it is all about permissions.
One other possible thing to check is whether NT authentication is being used, and if so, is it correct?
-- Anonymous, December 15, 2004