Re: The best elegant solution to override 65k rows limit in a sheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

you're crazy man.. go play with your BILLION DOLLAR DATABASES if you
want.

MDB is free; but still crap-- much like Excel.

MSDE/ADP is a free stack for all practical purposes. It has a FREE
front end called the Access Runtime-- it is a dream platform. And it
scales a LOT better than MDB.. I am tired of MDB; it is too slow; and
it really shoudlnt' ever be used from a mapped network drive--
performance is just too slow to do that.

That's what drives me crazy about MDB.. performance is worse than most
excel spreadsheets.. but it is a lot more powerful.

MSDE is the most powerful database in the WORLD.

Steve Ballmer says that 50% of the seats in the WORLD are SQL Server.
I know for a friggin fact it's true, dude.. I've been to 30 companies
over the past 7 years; I've seen 1 AS/400 and a half dozen oracle
boxes.. and HUNDREDS of SQL Server or MSDE boxes.

MSDE is an AWESOME stack for workgroups. I love it-- I just know that
this is a better choice than MDB at this point. MDB-- MS hasn't made
any exciting innovations in Access MDB for 10 years; and it pisses me
off.. They could start by making more drivers native.

There are 2 practical options these days-- mySql and SQL Server..
Oracle and IBM are bleeding red right now; IBM is keeling over like
we've never seen.. Oracle finally realizes that they're screwed on the
server front-- their products aren't UNBREAKABLE like they claim.

And SQL Server-- Analysis Services against Office Web Components-- it
makes beancounters like you irrelevant.

And the point of the matter--- IT SHOULDN'T OWN DATABASES. IT CAN OWN
THE SERVERS; DEPARTMENTS SHOULD OWN THE DATABASES.

Databases are a free and lovely and wonderfully flexible solution--
it's just that IT doesn't know whats best for databases... You design
databases in your department; and then you hand them off to IT.

I'm sorry that you work for a stodgy company.

if you use MDB; dont ever do anything across a mapped network drive--
performance drives me absolutely batty.

And SQL Server is the most popular db IN THE WORLD DUDE.

.

Quantcast