MS Access Newsgroups lack real synergistic help

[Larry Linson]

Interesting! My point still stands.

Not one MVP answered my questions.

All just pontificated and rationalized there indefensible positions.

First, you should be aware that not everyone who responds here is an MVP.
aaron kempf, for example, is not an MVP, nor does he often provide useful,
or even serious, responses to questions about Access. He appears to be, for
some reason, mentally pre-programmed to respond to all Access questions with
"move to SQL Server" whether or not that is an appropriate or useful answer.

Is it "pontificating" to explain that sometimes there is no "easy, simple
answer" that someone can just type in from memory? (See my comments below
regarding File IO.)

Is there some reason why John Vinson's approach does not work for you? Link
the external text file, open it as a Recordset, and try his code. Looks to
me to be worth a try.

If it doesn't work, post back with some details about the text file (fixed
field or delimited or ???) and someone can likely offer you a FileIO
solution -- as I don't do FileIO very often, any more, and as I don't have a
lot of time and energy to create a new example or to go search out an
example and revise it for your purposes, I might very well give you a link
or a reference to a resource. (Most of the VBA FileIO is not a great deal
different from the File IO from previous versions of BASIC, including the
DOS BASIC interpreters that came bundled with MS DOS and early versions of
Windows.)

I'm sorry you are unhappy with the level of response you are getting here in
microsoft.public.access; you might visit the USENET newsgroup
comp.databases.ms-access. Not nearly as many MVPs post there, anymore, but
there are still a lot of useful answers.

Larry Linson
Microsoft Office Access MVP

 

[Bob Larson]

AK is pointless and the only thing that he is good for with his existence is
to provide CO2 for plants. Other than that he is basically a self-centered
daddy's boy who wants and craves attention and tries to impart that he is an
expert in SQL Server but there is no evidence to follow that up as he posts
crappy suggestions and one-liners without backing any of it up with actual
data or valid arguments.

So, anyway - both SQL Server and Access have their place and neither one is
mutually exclusive. It is like saying that you should never buy a car but
instead always use a pickup truck because it can carry more stuff in the
back. Each has its uses and each performs similar tasks including getting
you from one place to another. But you would not buy a car if you needed to
haul dirt and gravel in it. You might not buy a pickup truck if you are
just interested in getting from point a to point b in the most economical
terms (less gas to run it). Same goes for SQL Server and Access. They
aren't necessarily the best for doing all jobs.

Bob L.

 

[Bob Larson]

This is not rocket science. Thank you so much for your time and
knowledge.

Wow, way to go in trying to insult anyone who might consider trying to help.
If you are really trying to alienate everyone so they don't answer your
questions you are off to a good start. Why the attitude? I think you
should just go pay Microsoft for support so that you get the answers you
want and you feel like you got your money's worth. At least if you don't
get what you want you can ask for your money back.

 

[Arvin Meyer [MVP]]

Folks,

What I learned today in this forum is that I spent good money for Access
when I should have
purchased SQL server. This is an Access NG correct?

SQL-Server would not have answered the particular problem you asked to
solve. SQL-Server may indeed be required if you have lots of records, but
you will still need a front-end capable of running code. By far, the best
solution for database front-ends is Access, that is assuming that you don't
require a large amount of WAN users.

 

[Tom Wickerath]

Eagle,

In addition to Bob's input, I recommend that you avoid using abbreviation.
In your previous post, you wrote:

"Have need to import massive 2MM plus record files from MF."

What is 2MM? Did you mean 2MB?
What is "MF"? Okay, the only thing that comes to mind when I see MF is our
resident troll, Aaron.

So, if you want your questions answered, try to avoid using abbreviations.

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[bcap]

Well you're the expert on bullying, dickhead.

whatever dude.. go flame the dipshit that claimed that you should
never use INT or BIGINT or UNIQUEIDENTIFIER as a pk

yes-- most of the people in these newsgroups have enough ability to
ignore the MVPs when they are wrong.
I've definitely noticed that they 'groupthink' and bully anyone that
has a different opinon

I applaud your questions--


YES it would be nice if there were 1000 times more websites for Access
-- in other words-- it would be nice if the technical resources that
are available to the Access (programmer) community -- it might be as
complete as the resources available for the sql community

but.. anyone with the balls to write professional level databases see
Access as a gateway to SQL Server.

In other words-- anyone that really gives a crap moves upstream to
sites like
http://www.sqlservercentral.com
http://www.sql-server-performance.com
http://www.sqldts.com


-Aaron

 

[Wayne-I-M]

Of course is doesn't - that's the whole point.

If you ask a question and someone answers then the answerer "must" have been
able to perform the task without the question being asked (or they would not
have known the answer), so there has not been a "synergistic" help process.

Synergism is the way 2 people will work together to produce something that
neither of them could have produced without the others help.

 

[Brendan Reynolds]

Of course is doesn't - that's the whole point.

If you ask a question and someone answers then the answerer "must" have
been
able to perform the task without the question being asked (or they would
not
have known the answer), so there has not been a "synergistic" help
process.

Synergism is the way 2 people will work together to produce something that
neither of them could have produced without the others help.

Well ...

Sometimes someone will ask a question to which I don't know the answer, and
if it sounds like an interesting problem and I'm not busy I'll go off and
figure out how to do it. I learned a lot about Access from answering other
people's questions, so I guess you could call that 'synergistic'?

 

[Wayne-I-M]

HHHhhhhhhmmmmmmmm



????

But is it "really". I would think that it means that both of the people
have to have some input into the answer - just asking the question is not
really "input". I can say to me mother than I want a nice cake but I want to
be blue and green. She will work out how to do this from experience and
(maybe) looking at other references (like a cooking book). But can be said
to have had some "input" into the creation of the cake.

But I will accept your view as my definition english came from Google and so
(if you have english as the 1st language) then you will know the best.

But - HHHhhhhmmmmm. I think thing may take a wry smile, a repeated slight
nodding of the head and (maybe) a rised eyebrow with a knowing smile.

 

[EagleOne@microsoftdiscussiongroups]

If all Gods have returned from Access heaven and have cooled off, let us try
this another time.

The questions were/are simple. Real simple. All that was asked was a VBA
code line to remove from report headers from a text import. Simple stuff?

Next was can anyone share a macro that contains the VBA to name headings and
set data types which I could modify for my use.

Any response that initially came back was overbroad, assumed the worst,
assumed that some Access wacko was intentially screwing with the Access Gods.

In reality, I am just user who asked simple question(s). But the Access
Gods are so used to intimidating (browbeating, holyer-than-thouing) the user
with imagined abuses never substatuated or in play. All but one walked right
passed and never came back to the mission of this Forum.

Never have I seen a "professional group" so threat sensitive. There were
those in the group who stated that SQL Server was the only answer -
essentially Access is junk. The software I have is Access and I therefore I
must use it.

This would have gone much smother if Access Guru's were willing to share
their knowledge. Just look at the number of Excel postings which contain
actual VBA code or real formulas that work! How amazing. Compare that to
Access NG! What one can see is more questions than answers. What results in
User's minds is "Access is to difficult to understand, I'll just limp with
Excel limits". Which of course smacks at self-serving their consulting
businesses.

In Access, a question is asked and the third-degree interigrators jump in
you face with more questions than answers. To be sure, some of that is
needed. But in reality it is much more like "I paid my dues; I could not get
help; I did it on my own; I am going to make you (the user) bleed first then
I might consider giving you something that you could to solve an issue at
hand and make Access-use a blessing.

This news group should be more about empowerment than about hazing and
self-service that it is in reality.

 

[a a r o n _ k e m p f]

you just choose to listen to the snake oil salesman.
Is that my fault?

I choose a real database engine-- paired with Access forms and
reports-- for the same cost as JET

ADP forever, baby.

 

[a a r o n _ k e m p f]

Access rocks.

but SQL Server is about 100 times better in every direction.
SQL Server is free.

www.microsoft.com/sql

if you've got Access 2007; use SQL 2005.
if you've got < Access 2007; use SQL 2000

either way, use SQL Server Management Studio Express in order to
manage the db server (as it has more power than ADP).
But for most developkment-- just use ADP

 

[a a r o n _ k e m p f]

Larry;

eat shit-- so sorry that you don't have the mental capacity to learn
the 'worlds most popular database'
(source = www.microsoft.com/sql)

It's not my fault that you're stuck usign DAO and you have to spend
all your time writing connection strings.

ADP 'just works'.
You should have gotten on that train a long time ago.

 

[a a r o n _ k e m p f]

bullshit; Jet is not reliable enough for more than a single user and a
single record

 

[a a r o n _ k e m p f]

ADP is a great front end.

It looks just like MS Access-- same forms and reports-- but the query
engine is much faster and superior.

It supports 'code reuse' for starters

 

[a a r o n _ k e m p f]

Chris;

I've heard MS Employees bad-mouth Access thousands of times. Check
your facts, kid.
I've worked at Microsoft for what, 6 different contracts?

MS is full of Excel dorks. They are blinded by Excel.

I've never met anyone at MS that is not a blue-blood excel dork.
Maybe that is why they never had enough Cojones to take the JET
database engine seriously.

Maybe if they took JET seriously-- maybe they wouldn't have killed it
off (a decade ago)

 

[Bob Larson]

Go E S A D Miss Aaron.

you just choose to listen to the snake oil salesman.
Is that my fault?

I choose a real database engine-- paired with Access forms and
reports-- for the same cost as JET

ADP forever, baby.

 

[Bob Larson]

Oh, you say you worked at MS but you are just lying like the piece of sh@#
you are. You have no proof Miss Aaron.

Chris;

I've heard MS Employees bad-mouth Access thousands of times. Check
your facts, kid.
I've worked at Microsoft for what, 6 different contracts?

MS is full of Excel dorks. They are blinded by Excel.

I've never met anyone at MS that is not a blue-blood excel dork.
Maybe that is why they never had enough Cojones to take the JET
database engine seriously.

Maybe if they took JET seriously-- maybe they wouldn't have killed it
off (a decade ago)

 

[a a r o n _ k e m p f]

whatever, Bob.

Try to be civil on this newsgroup.
Some pansy might call the cops on you (for having the audacity to
_SWEAR_ on a newsgroup? )

-Aaron

 

[Bob Larson]

Oh that's like the pot calling the kettle black. You aren't civil so take
an enema. You aren't even a man so FO.

whatever, Bob.

Try to be civil on this newsgroup.
Some pansy might call the cops on you (for having the audacity to
_SWEAR_ on a newsgroup? )

-Aaron