What MS Access version to use?

T

TC

Take your squabble to email.


No - for this reason:

He frequently posts incorrect information about Access, coupled with
bad advice that people would do best to ignore. For example:
- You have to spend lots of time continually relinking tables;
- Access can not handle nested queries, so you should not use them;
- Access can not handle subqueries, so you should not use those either,
and so on.

It's important to reject those statements publically, so other people
reading them, now or in future, can take them with a grain of salt.
Otherwise, the usefulness of these newsgroups is gradually eroded, as
more and more personal prejudices are posted in the guise of facts.

People who read his posts, & my replies, soon see what is going on, and
are free to ignore us both, when we speak to each-other. I already
tried to broker a peace agreement:
http://groups.google.com/group/microsoft.public.access/msg/2bbb2fc97f8bf9fb
but he broke that agreement, and has gone back to posting incorrect
information, and bad advice.

As soon as he stops posting incorrect information, and bad advice, in
public technical newsgroups, I will stop getting into him. Believe me,
there are far more things that I'd rather do with my time; for example,
answer questions in these newsgroups!

Cheers,
TC [MVP Access]
 
A

aaron.kempf

incorrect?

MDB IS A PIECE OF SHIT AS ARE YOU!!!

you're attacking my integrity?

just because you know that you're wrong?

eat shit it's personal now asshole

MDB isn't fit to be sold. Microsoft should be charged with FRAUD for
selling such buggy software.

i mean.. how many workarounds do you HAVE TO USE every day?

queries on top of queries crap out

Access MDB isn't reliable enough for a single user and a single record.

i'm not posting BAD ADVICE

im posting the advice that you MDB sissies are a bunch of lazy idiots;
there is a better way-- it is called SQL Server kids
 
A

aaron.kempf

i broke the agreement?

you mdb sissies continued to spew lies and deceipt about ADP.

do you think that IM the one that broke the cease fire?

your silly mdb wimp henchmen decided YET AGAIN that mdb is the only
way-- do you know why?

BECAUSE YOU WIMPS ARE TOO LAZY TO LEARN TSQL

it's more powerful than vba; give it up kids
 
T

Tony Toews

i broke the agreement?

you mdb sissies continued to spew lies and deceipt about ADP.

What lies and deceits?
do you think that IM the one that broke the cease fire?

What cease fire?
your silly mdb wimp henchmen decided YET AGAIN that mdb is the only
way-- do you know why?

BECAUSE YOU WIMPS ARE TOO LAZY TO LEARN TSQL

it's more powerful than vba; give it up kids

Ok.

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
 
T

Tom Ellison

Wow!

As an Access developer who works almost exclusively with ADPs and MSDE (I am
a SQL Server Magazine Innovator award winner for 2003), and as someone who
knows most of the Access MVPs personally, I have to say you are quite
mistaken about most MVP's capabilities. Some of them do prefer Jet, for
reasons of their own situation and requirements. While I do not prefer Jet,
I still answer questions in this newsgroup, assuming the questions are
mostly for Jet. It can be difficult to get some of the more complex
solutions running.

I have spoken with many of my MVP colleagues and encouraged their use of SQL
Server. None of them lacks competence to do so, but they are using their
best judgment in selecting Jet for their needs. I do not have the same
needs, and am in no position to try to judge theirs. When they tell me that
Jet is faster for their purposes, I take it with a grain of salt. I
personally have performed some of the more difficult challenges I have faced
using both Jet and SQL Server. In some cases, I have found that a SQL
Server solution can be 500 times as fast when things get really difficult.

I suggest that TSQL and VBA are not competing solutions for most purposes.
But, yes, given those purposes for which either could be used, I'd choose
SQL Server.

So, if you're happy with this, I'm one who does promote the ADP as an
excellent solution. For my development needs it is really indispensable.
The MVPs I know have never even taken issue with my convictions on this.
Given the same challenges, I believe most of them would soon see the need
and would work with ADPs or with MDBs and pass-thru queries to MSDE. They
are very good at making strategic decisions and adopting new technologies
when warranted.

They would argue that, in it's niche, MDBs and Jet do very well, indeed. I
also agree with this. I'm not out to proselytize them, but I have made sure
they understand an alternate viewpoint. This they have respected. As soon
as they realized I wasn't out to act superior and denegrate what they do,
everything has been fine.

As has been said, you catch more flies with honey. Please give it a try!

Tom Ellison
 
T

Tony Toews

Tom Ellison said:

Tom!!!!

Great to see you back again. Your opinions as always are greatly
appreciated.

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
 
T

Tom Ellison

Hi Tony,

I've been posting almost daily a bit over 3 months now. I just haven't
crossed paths with you till now.

Hope everything is well with you!

So, have you given up avoiding controversy? :)

Chuckle!

Tom
 
A

aaron.kempf

no we had an agreement..

you dorks stop slamming ADP
and i stop telling you to eat shit for breakfast

you guys broke the truce; so there you go tony; eat shit for breakfast

MDB is the worst platform ever; and you guys are all stuck in the 80s.

I mean.. aren't you tired of Front End Update this and table refresh
this and omg, i need to update a query on 12 people's desktops

i mean.. dont you think that just POSSIBLY there is a better way?

update, relink, refresh, copy, paste, CRASH

query on top of query CRASH

CRAPOUT CRAPOUT obnoxious error message CRASH CRASH CRAPOUT ERROR
MESSAGE

uh, 'the paramete is incorrect'

uh 'the expression is too complex to be evaluated'

eat shit and die MDB wimps
i dont have to deal with any of that CRAP in my happy little ADP world
 
T

Tony Toews

Tom Ellison said:
I've been posting almost daily a bit over 3 months now. I just haven't
crossed paths with you till now.

Obviously. said:
Hope everything is well with you!
Ayup.

So, have you given up avoiding controversy? :)

I wish.

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
 
D

dbahooker

you guys, you mvp wimps?

you guys have been talking shit about how it's not going to be around
in the next version of office

AND NOW WE SEE IT WILL BE IN THE NEXT VERSION, HUH?

because of that you have all demonstrated your ineptitude and if this
was cuba and i was castro?
i would have all you mvp wimps shot for treason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top