ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> MS Query - Data not updating when I make changes.
http://www.istechforum.com/YaBB.pl?num=1323113994

Message started by AndyOB on 12/05/11 at 12:39:54

Title: MS Query - Data not updating when I make changes.
Post by AndyOB on 12/05/11 at 12:39:54

So I pulled the MTICMSTR and BKICMSTR tables into Excel using a MS Query to a PivotTable.

This works great, I love it, but here's the problem:

If I make a change to an item (IN-B), and change something like the Class, save the item, exit Evo, then go back into Excel and refresh the data, nothing changes.

I was trying to get the answer from Lynn, but I guess they went on xmas break this week, and I need to do this report before the holidays.

Any help appreciated. 408-942-1106 if you wanna call and ask for Andy, I'd appreciate it.

-A.

Title: Re: MS Query - Data not updating when I make chang
Post by GasGiant on 12/05/11 at 14:10:25

Hopefully you are updating both the data and the pivot table itself. If you are pulling directly into a pivot table you might try pulling the data into one sheet and creating the pivot table from the data worksheet.

Title: Re: MS Query - Data not updating when I make chang
Post by AndyOB on 12/05/11 at 14:47:01

I tried that, same problem. I tried making a new pivot table, I tried reading the data onto a seperate sheet and making the pivottable from there. No luck.

When I go to refresh all, it looks like Excel is reading data from Evo, but the data never updates.

Makes no sense to me.

Title: Re: MS Query - Data not updating when I make chang
Post by AndyOB on 12/05/11 at 14:59:42

Crud, this may be an issue.

OK a while back we moved DBA from Server A to Server B.

If I go to the ODBC data connection page it's pointing to Server A.

Using Pervasive Control Center it seems as though the DBA data I am accessing (Evo, whatever) is on Server A. Does this work? Evo is definatly running off server B, but ODBC is pointing to Server A.

Also if I check Server B using Pervasive, only DEMODATA comes up for Data Source Name. When I click Create... I have no idea what login to put there. What am I missing here?

-A.

Title: Re: MS Query - Data not updating when I make chang
Post by AndyOB on 12/05/11 at 15:57:59

Fixed, I'm a goof. I was pulling data out of the old server via ODBC. Setup ODBC on the new server, problem solved. Blah.

Title: Re: MS Query - Data not updating when I make chang
Post by Kelloggs on 12/06/11 at 11:18:55

Sub Auto_Open()
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub

:P

Kelloggs