AngeloWolfe
New member
- Local time
- Today, 09:36
- Joined
- Jun 22, 2011
- Messages
- 6
Greetings to you AW! I want to first thank you all for the information you have previously put out in regards to multiple minor problems I've had with dealing with Access. On that note, the question I have is a little unfamiliar, and I haven't seen any previous topics concerning it... here we go!
So, I am working with an Access 2007 database that is connected to a SQL Server that hosts LOTS of data. In a nutshell, it has records of half-hourly information recorded with different statistics. I want to take this data, and query it down to show sums, different individual ID statistics, volumes, etc...
The problem is that the linked tables are hosting up to 17 MILLION records. So, when I try to query down and filter that information... the Database explodes.
My original idea is to create a TempVar or temp table that would host the data separately, so I could query off of data not having to relink and go through every record for every query... but I'm not used to the coding lingo of modules and VBA with Access 2007, haha.
So, I wanted to see if you guys had any input on how I could make handling this information a bit easier and a way to improve performance when dealing with this amount of data.
Thanks in advance!
So, I am working with an Access 2007 database that is connected to a SQL Server that hosts LOTS of data. In a nutshell, it has records of half-hourly information recorded with different statistics. I want to take this data, and query it down to show sums, different individual ID statistics, volumes, etc...
The problem is that the linked tables are hosting up to 17 MILLION records. So, when I try to query down and filter that information... the Database explodes.
My original idea is to create a TempVar or temp table that would host the data separately, so I could query off of data not having to relink and go through every record for every query... but I'm not used to the coding lingo of modules and VBA with Access 2007, haha.
So, I wanted to see if you guys had any input on how I could make handling this information a bit easier and a way to improve performance when dealing with this amount of data.
Thanks in advance!
