Using ADO in an mdb application

[Robert Morley]

<Aaron's entire post snipped because it was idiotically huge.>

Wow, all that just to prove my statements correct. You sure do take a long
time to get your point across. (PS, my wording on the MDAC thing was a
little misleading; it would have been better stated as "included in MDAC
until 2.6, at which point they removed it".)

As for the rest of it, I said specifically, that it was "included", not that
it was the "default" or what-have-you.

As I said previously, the OP started with the statement that he was
converting from DAO to ADO, so DAO became relevant to the discussion at that
point.

Oh and one last thing Aaron, dear, you might want to get your facts straight
before you accuse me of spreading my DAO ways all over this group: I
haven't used DAO for anything in 3 years. That doesn't negate the fact that
it's still MUCH faster on native Jet databases.



Rob

 

[Robert Morley]

True enough. Hadn't considered that permutation, since the OP was speaking
specifically of migrating to SQL Server, but you're right of course.


Rob

 

[Robert Morley]

Where on EARTH did you get that idea?!? I'm sorry to burst your bubble, but
Canada didn't go through the various race issues that you did in the US. I
don't give a rat's asinine posterior what colour your skin is.


Rob

 

[Robert Morley]

DAO HAS BEEN DED FOR A DECADE KID

STFU and start talking to me with some respect

Why should ANYBODY talk to you with respect when you actively denigrate
them?



Rob

 

[Robert Morley]

JET and DAO haven't been included with Office, MDAC or WINDOWS for 10

years

You just proved your own incorrectness a few messages ago. Why do you
insist on your lies? They have been *included* in all of them up until
about 3 years ago, give or take, and depending on which one you're talking
about.

 

[Larry Linson]

this is an ADP newsgroup; if you say ANYTHING
anti-ADP you will pay the price

Mr. Kempf, that surely seems a strange statement to appear in a post in
newsgroup microsoft.public.access.modulesDAOvba. (emphasis mine) Perhaps you
should take a look at the newsgroups list to see what newsgroups have been
crossposted before making such rash statements.

Larry Linson
Microsoft Access MVP

 

[Graham R Seach]

Just curious Aaron,

What was the bug that led to you having to work for free for 3 months?

Regards,
Graham R Seach
MSysDev, MCAD.Net, MCSD.Net, MCP
Microsoft Access MVP
Sydney, Australia

 

[Aaron Kempf]

some crash in a UDF of a ADP

I put a UDF in a WHERE CLAUSE of an ADP and it caused an intermittent crash

it was Access 2000
against SQL 2000

 

[Aaron Kempf]

Canada? Are they still around?

I thought that we annexed them; or someone did

you know-- I got kicked out of 11th grade english class for writing a paper
about why we should invade canada

I got kicked out of the english class, because my teacher found it offensive
that I was talking about how we should invade canada

 

[Aaron Kempf]

DAO has been depecreated.

it hasn't been included with Office, Windows or MDAC for a decade.
ADP just got a huge facelift in Access 2007

 

[Aaron Kempf]

it isn't faster.. because there is no such thing as an 'Access Database'

you'd say the same thing if you had as much of a hard time with corruptiond
and poor performance as I have

 

[Aaron Kempf]

10 years?

sorry-- since the fall of '99... I meant to say EIGHT YEARS not 10 sorry

 

[Aaron Kempf]

and for the record, there IS a new version of ADO in vista.

there is NOT a new version of DAO in vista

 

[Aaron Kempf]

because I've been the only one out here; speaking the truth for the past 5
years

 

[Aaron Kempf]

David

you are wrong, there is no such thing as MDB

 

[Robert Morley]

Okay, let me try another tactic, then: the sky is blue.


Rob

 

[Robert Morley]

Well, you've been speaking SOMETHING, but it's most definitely not the
truth, as earlier posts have proven. But let's say for the moment that you
had been...that STILL doesn't justify your attitude towards others,
denigrating them and then turning around and expecting THEM to give you
respect!

You gotta show some to get some.



Rob

 

[Graham R Seach]

Hmm, Tough break. Did you ever work out what the exact problem was?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Aaron Kempf]

what are you talking about kid

In the past 10 years, I've never heard Access referred to as a DATABASE

Access is a FRONTEND


STFU and lose the training wheels, kids

 

[Aaron Kempf]

I speak the truth

I do it proudly and I refuse to let you guys convince newbies to become
Access MDB dorks

the world needs more SQL Server Developers

this whole Access MDB thing has been obsolete for a decade