error on sql usage

This topic is locked

error on sql usage	8/20/2005 11:30:10 AM
ASPRunnerPro General questions
author Hi all, I am in the process of moving from a access db to a SQL one, and have started to transfer over the pages. However when I try to access the page I get Error number -2147217911 Error description [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'DVD', database 'db', owner 'dbo'. Does anyone have any ideas? Thanks


	admin 8/22/2005
	Julie, you need to check permissions for 'DVD' table in your database. To do this open the list of tables using SQL Server Enterprise Manager. Highlight 'DVD' table and right click on it. Choose All tasks-Manage Permissions... and set all necessary permissions on this table for Public or that user you use for ASPRunner connecting.