Thanks.

I am actually starting from VBA within a spreadsheet and executing a SQL string from within there.

The reason I'm so confused is that running the identical string with the same source location directly in SQL Server studio works fine with no errors, then trying to do so from VBA gives me the error which, as you say, seems to be permissions based.

I feel I may be slightly out of my depth here but was hoping this could esily be resolved.