MS access size issue???

[Guest]

Yes, perhaps 'random' was a poor choice of word.
'arbitrary' is a better word.

However, see my comments on aggregate queries in general.
With complex nested aggregate queries, first and last cannot
be depended on to return records by 'disk order' or even by
'order by' order. Presumably there are join or group-by operations
that have the effect of changing the sort order. This problem
pre-dates the change to disk sort order, although I didn't realise
it at the time.

(david)

 

[dbahooker]

there is nothing wrong with aggregate queries

if you're serious about them-- then look into Analysis Services..

SSAS is a free component with SQL Server Standard and higher.. and
it's a friggin great solution; I absoultely love SSAS


if your database can't use SSAS then you need a new database.

 

[Matt]

there is nothing wrong with aggregate queries

if you're serious about them-- then look into Analysis Services..

SSAS is a free component with SQL Server Standard and higher.. and
it's a friggin great solution; I absoultely love SSAS

if your database can't use SSAS then you need a new database.





- Show quoted text -

You have such command of the english language kemffff. I love your
nicer alter ego , although equally inept at speaking/typing, she is
much more plesant!

 

[Susie DBA [MSFT]]

at least I'm not a MDB _WUSS_

stick it buddy.. you kids are stuck in the 80s

 

[Tony Toews [MVP]]

at least I'm not a MDB _WUSS_

stick it buddy.. you kids are stuck in the 80s

Umm, Access was first available in 1992.

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Matt]

at least I'm not a MDB _WUSS_

stick it buddy.. you kids are stuck in the 80s






- Show quoted text -

Stuck in the 80's ... Susie Kemffffff the dbahooker uses insults like
"stick it buddy" and then accuses other people of being lame and stuck
in the 80's. Cowabunga dude.

 

[aaron.kempf]

wtf are you talking about kid

MDB is for retards

anyone using MDB in the year 2007-- when all 3 vendors have a freeware
version?

People who use MDB should be FIRED and then spit upon