Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Gaffers]

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?

[Chris_H]

I never knew Access could handle large amounts of data.  Especially if there were more than a few users sharing.

Has it improved?

[Gaffers]

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 

[cem_devecioglu]

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 :-/

[Gaffers]

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

[cem_devecioglu]

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..

[cem_devecioglu]

or like this
http://msdn.microsoft.com/en-us/library/aa662945(v=office.11).aspx

[Gaffers]

or like this
http://msdn.microsoft.com/en-us/library/aa662945(v=office.11).aspx

Good find, that will help me

[cem_devecioglu]

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..)

[Sixstring]

Didn't know you were completely proficient in swahili mate.......

That is what you are speaking about???

pivots??


engineering??

[Gaffers]

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