ISTech Support Forum - MS Query - Data not updating when I make changes.

Welcome, Guest. Please Login.

	05/14/25 at 03:04:54 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›

Pages: 1

MS Query - Data not updating when I make changes. (Read 1188 times)

AndyOB

Full Member

Humm...

Posts: 154
Gender: male

MS Query - Data not updating when I make changes.
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.

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA

IP Logged

GasGiant Administrator How can I help? Posts: 1517 Gender:	Re: MS Query - Data not updating when I make chang Reply #1 - 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.
Back to top	IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: MS Query - Data not updating when I make chang Reply #2 - 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.
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

AndyOB

Full Member

Humm...

Posts: 154
Gender: male

Re: MS Query - Data not updating when I make chang
Reply #3 - 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.

--
Andy O'Brien of Nortra Cables, Inc.
Milpitas, CA

IP Logged

AndyOB Full Member Humm... Posts: 154 Gender:	Re: MS Query - Data not updating when I make chang Reply #4 - 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.
Back to top	-- Andy O'Brien of Nortra Cables, Inc. Milpitas, CA IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: MS Query - Data not updating when I make chang Reply #5 - 12/06/11 at 11:18:55 Sub Auto_Open() ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh End Sub Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Items

‹ Previous topic | Next topic ›