Execute permissions on a table?

[Zippeh]

Im having problems adding new data to a table using ASP with SQL Server 6.5

Even though im doing exactly the same thing as I have done with another ASP file with another table in the same database, i get the:

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object....blah blah blah error.

What i dont get is that i cant add Execute permissions on a table, so why does it say that i havent got Execute permissions on something that cant have Execute permissions?

Pleeeeeeeeease someone help meeee

 

[rt63]

R u sure it is EXECUTE PERMISSION on table or is it on a procedure which you may be executing from ASP (which in turn updates tables)? Can you display the complete error message?


RT

 

[Zippeh]

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object tbl_Staff, database DB1, owner dbo

is the whole error message.

Here is the ASP that im trying to execute on it:

objRs.Open "tbl_Staff", strConnect, adLockOptimistic, adCmdTable
objRs.AddNew
objRs("id_staff&quot=Request.QueryString("id_staff&quot
objRs("rhif_hil&quot=Request.Form("hil&quot
objRs.Update