Re: why>?

dbahoo...@xxxxxxxxxxx wrote...
....
but newbies shouldn't have to do that since ADP has such a nice
interface for writing sprocs and views.
....

But if the average business user can't create tables or views or modify
anything in SQL Server because they lack the necessary
permissions/rights, how would ADP help them?

i wish i could spend more time teaching people Accesss.
....

If you spent less time whining about Excel . . .

Excel 2007 has some really really exciting technologies.. the ability
to import olap data as either a table or a pivotTable-- that's going to
revolutionize the way that we do business.
....

Not really. Aside from some reports (I didn't make 'em, and I' not
responsible for 'em), none of the spread*** models in widespread use
where I work involve pivot tables. Pivot tables may have their uses in
reporting, but much less so in analysis.

And all you need is

a) SQL Server Standard Edition
b) office license.
....

And if your company's databases are all in Oracle or DB2 or (who knows)
mySQL? And you need to set up the OLAP cubes, but I'll stipulate that
may not be difficult if there's someone who knows how to do it. All I
can say is that there are lots of companies either without (a) or who
don't provide most users with access to it.

.