Omega Owners Forum
Chat Area => General Discussion Area => Topic started by: Gaffers on 10 January 2011, 20:27:01
-
Back in my programmer days I spent a long time developing and debugging various Access applications and although I havent changed employer it looks as though I may be going back in to that as there is a potentially lifechanging opportunity on the horizon.
I have been told to look at pivot tables, I left the programming world just as they were added as a feature so I have yet to play with them. They seem straightforward enough, but I am interested in your own experiences/problems.
The system I am looking at working on handles a huge amount of data and the current usage of various forms/tables could be condensed into one or two with a pivot table. Sounds interesting but like I said...what do you think?
-
I never knew Access could handle large amounts of data. Especially if there were more than a few users sharing.
Has it improved?
-
I never knew Access could handle large amounts of data. Especially if there were more than a few users sharing.
Has it improved?
Quite a lot, this system has several iterations all communicating with each other and the central DB all using data gather from 3 other sources either directly or through a datadump. All of them work on different shared network drives too. I remember when it would fall over if 3 people opened the same copy ;D
-
Back in my programmer days I spent a long time developing and debugging various Access applications and although I havent changed employer it looks as though I may be going back in to that as there is a potentially lifechanging opportunity on the horizon.
I have been told to look at pivot tables, I left the programming world just as they were added as a feature so I have yet to play with them. They seem straightforward enough, but I am interested in your own experiences/problems.
The system I am looking at working on handles a huge amount of data and the current usage of various forms/tables could be condensed into one or two with a pivot table. Sounds interesting but like I said...what do you think?
can you define huge..
both oracle and sqlserver have special tools/commands/programming languages built in to handle those kind of jobs (like mdx).. olap, rolap etc..
unfortunately no idea about access :-/
-
Not so much as to cause Access a problem, but more than just your simple 2D table.
No way that we can upgrade to anything other than Access, finances and continued maintenance dictates
-
Not so much as to cause Access a problem, but more than just your simple 2D table.
No way that we can upgrade to anything other than Access, finances and continued maintenance dictates
2 choices , if access can realy handle the data it has some pivot options
like this one http://www.blueclaw-db.com/accessquerysql/pivot_query.htm
or
back to conventional method of 3d ,4d... matrixes with some programming language..
-
or like this
http://msdn.microsoft.com/en-us/library/aa662945(v=office.11).aspx
-
or like this
http://msdn.microsoft.com/en-us/library/aa662945(v=office.11).aspx
Good find, that will help me :y
-
and I must state that I would prefer conventional matrix programming as it gives you total control over others , but being slower than direct pivoting transact sql..( thats valid for mssql and oracle not tested on access..)
-
Didn't know you were completely proficient in swahili mate.......
That is what you are speaking about???
pivots??
engineering??
-
and I must state that I would prefer conventional matrix programming as it gives you total control over others , but being slower than direct pivoting transact sql..( thats valid for mssql and oracle not tested on access..)
me too, I would love nothing better than to slap a nice Oracle DB in there but I am very very restricted as to what products, even the version I can use