You're full of crap. It's no point in 'attacking my knowledge'--
because I am like the _ONLY_ person here with a single cert that they
earned.
Yep; that is correct-- Im a MCITP: Database Administrator.
Is there a _SINGLE_ other certified person in this newsgroup?
Most people grow from Access-> SQL Server and never look back.
I honestly love ADP more than almost anything else in this world-- So
it is my job to enlighten the 'unclean'.
I've worked on more Access MDB databases than 90% of the people here.
It burned me. I used to support 20 people that spent 40 hours a week
typing stuff into 60 different Access databases.
a dozen databases that were larger than 1gb.
and they all took 60 seconds to launch and about 5 seconds to move
from record to record.
Yes-- I'll admit-- performance might have increased 10% (percent) when
we moved from a 10mbit hun to 100 mb switches everywhere (after we
went through our IPO).. but it was still unusable.
It didn't warrant a re-write. It warranted a whole new architecture.
It wasn't worth the time and effort in rewriting a bunch of crap in
MDB.
Because _I_ for one have a brain--
Fool me once, shame on you.
Fool me twice; and i'll leave your piece of crap database on the side
of the road.
I gave it up-- just like you should stop shooting heroin.
If it corrupts a single record _EVER_ and you continue using it-- then
you are an addict to heroin.
Some crashes are just unexplainable.
_ESPECIALLY_ back in the day of 9x. If you sell a piece of shit
'dodge neon' for 12 years.. and then all of a sudden it's the perfect
car for me-- do you think that I'd give it a chance??!!??
HELL NO-- If it's a POS car once; it's always a POS car in my book.
Access MDB lost it's ability to be a database when it would crash once
a _YEAR_ without explantion.
None of your 'oh, just split it' crap would explain it.. I mean what a
friggin joke.
It was split-- it was properly written-- other than the fact it was on
a crap platform.
Would you build a warship out of bamboo?
If you're ANY sort of professional, building databases-- and they're
not written in SQL Server-- you might as well be using NotePad.
Because NotePad is more powerful, faster, more reliable-- and has more
functionality than MS Access.
a) Access MDB has close to _ZERO_ profiling capabilities - this might
have improved in Access2007 but that was what, 4 versions too late for
me to give MDB a chance?
b) There isn't a person in the world that can properly index MDB
files. Even if you've got 3 columns in a table-- there isnt' a
possiblity in this world-- that you guys could claim that Access
'properly indexes' tables. Access indexing is a joke. I could beat
almost _ANY_ query (performance wise) in Access by a 5:1 factor; using
indexes that INCLUDE data. With Access; even if you attempt to make a
covering index; this makes it more difficult than necessary because it
creates a _LEVEL_ in the index for each column you're indexing. I
don't want a level for TotalSalesAmount-- I don't want or need a 3
level index-- that is like 8 times more complex than it needs to be--
the 3rd column is a measure. (if you guys don't know what a measure
is; go and pick up a book, script kiddies). Having every index 1/3rd
too big _AND_ too slow-- in this single regard-- is enough for me to
move on.
c) Just because you guys can't spell SQL-- that doesn't mean that it
is 'too complex'.
Seriously. It's not too complex. You just choose to listen to
dipshits that are stuck 'in the first grade of the db world'.
It means that you guys are talking to a bunch of blue-hairs that
don't know WTF they're talking about-- because they are stuck with 15
year old tech.
Yes, MDB is obsolete. ACCDB might be better- but if I wanted
sharePoint shoved up my ying-yang; I'd use Internet Exploder, not MS
Access.
-Aaron