Community
Showing results for 
Search instead for 
Do you mean 
Reply

looking for someone to support with OLE DB queries from Excel not updating

Silver Contributor
Posts: 1,781
Country: United_Kingdom

Re: looking for someone to support with OLE DB queries from Excel not updating

Before trying anything else try rebuilding the OLDB report objects in the database via ACTDIAG - 

 

 

Nickel Super Contributor
Posts: 414
Country: United_Kingdom

Re: looking for someone to support with OLE DB queries from Excel not updating

Good shout ch1p, forgot about that
Highlighted
New Member
Posts: 6
Country: United_Kingdom

Re: looking for someone to support with OLE DB queries from Excel not updating

Hi both, 

 

We have run the ACTDIAG on the server and no change.  So first we are going to upgrade from v20 to v21.  By changing the query to use statusnum instead of status we did get fields back, although none of the open ones. 

 

Anyway,  so step 1 upgrade,  step 2 run ACTDIAG again.  Then I expect I'll be back on this thread.  I'd really love to find someone who we could just contract a few days work to sort it for us!!

 

Silver Contributor
Posts: 1,781
Country: United_Kingdom

Re: looking for someone to support with OLE DB queries from Excel not updating

Try sending a message to Roy who is a wiz at reports and creating scripts so maybe the person you are looking for -

 

https://community.act.com/t5/user/viewprofilepage/user-id/324