[AccessD] Pass thru Query - SQL Server

On 6 Jul 2006 at 15:05, Kaup, Chester wrote:

> I have the following pass through query to SQL server. The table it
> tries to access will open. I have verified the table name and field
> names. I have write permission to the table. If someone knows some SQL
> server stuff your help would be appreciated.
> 
> EXEC sp_rename 'dbo_SurfaceMaster.UWI', 'API10', 'COLUMN';
> 

What sort of error are you getting?

Do you have Execute permission on the sp?

What is it renaming? Are you changing a table structure here? If so, you 
need more that just Write permission on the table, you must be logged in 
with a role that permits Altering objects.

-- 
Stuart