Community
Showing results for 
Search instead for 
Do you mean 
Reply

Created a SQL view of ACT data, but getting error message

New Member
Posts: 4
Country: USA

Created a SQL view of ACT data, but getting error message

Using ACT Pro 2011.

 

We are desperately trying to work out a way to use data in Opportunities to create file folder labels.  Since you can't merge from Opportunities, this is proving quite difficult.

 

I had someone who knows SQL very well work on this.  He created a view that did exactly what we need and it worked yesterday.  However, when I tried to use it today I get the following error in Word:

 

"Error has occured:  The SELECT permission was denied on the object 'VE_FILE_LABEL', database 'UIS1', schema 'dbo'.

 

Something in ACT seems to be turning off the permissions on this view automatically.  Can someone please help. 

 

If this is not the way to go about solving our issue with using data in Opportunities to merge to a Word template, can someone suggest a way that would work?