Recent content by magicarty

OK, so it took fore.ev.er but I tried adding a ton of indexes and such. Problem is when you access the pivot from Excel, it still takes just as long (I think) because it still has to re-look at the data from the pivotcache as it's no longer looking at the data connection. In my current setup, I...

Seriously. Anyway, I'm working on trying to index where I can right now. I assume that since this is a make table query by way of a pass through, I have to run another query to create the indexes on the table after-the-fact? What's the structure? I was assuming something like CREATE INDEX on...

I haven't, but how much faster would that make it? Do Excel pivots care about indexes in Access databases? I'd probably have to do like 15 of them because of how many ways people may want to spin the data?

Let me try and be more clear... I currently have Access use a pull through query to grab about 60 columns and about a million rows of data from our data warehouse via ODBC connection. Then I basically use Access as a pivot cache for an Excel doc to make everything prettier and easier to use for...

I currently have Access use a pull through query to grab about 60 columns and about a million rows of data from our data warehouse via ODBC connection. Then I basically use Access as a pivot cache for an Excel doc to make everything prettier and easier to use for my customers. Unfortunately...

I've got a table of associate directors "t_ADnames" and want to build separate tables for each AD name that pulls a pass through query from our data warehouse. I'm thinking it's got to be done with a macro somehow? So it would run pass_query where AD name = "John" and insert into t_john...

I've got a table of associate directors "t_ADnames" and want to build separate tables for each AD name that pulls a pass through query from our data warehouse. I'm thinking it's got to be done with a macro somehow? So it would run pass_query where AD name = "John" and insert into t_john, then it...