Unanswered: Required permissions for running TextCopy?
I posted this last week, but unfortunately it was lost. So here 'tis again.
I am having trouble with working out what permissions a user needs to run the Textcopy function.
I have setup a stored procedure on the server which runs Textcopy to insert/export a GIF file to/from a network location to an Image field of a database. The stored procedure is called from an Access97 frontend.
It all works fine when the user on the client PC has SQL Server System Administrator permissions, however when the client PC is logged in as a normal user without these permission, the operation fails. Giving the user System Admin permissions fixes the problem, but obviously I can't do this for all the users!
Does anyone have any idea exactly what individual items I need to set permissions for to enable Textcopy to run??
Any hints at all, (no matter how small) would be much appreciated.