MS Access Newsgroups lack real synergistic help

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.

wrote in message
...
At the end of the day have you made any positive progress in this Forum?
I think not.

a a r o n _ k e m p f wrote:

if you've been using Access for that long-- you'd be using SQL Server
by now. I guarantee it.
Access is just a speed bump on the path towards SQL Server.

A pothole.
A driveway to the information super highway that is 'SQL Server'.

You're kidding yourself.
It is inconcievable that you have this much experience with Access and
yet you cannot spell SQL Server







On Jul 27, 5:45 pm, "Arvin Meyer [MVP]" wrote:
That's odd. I've been on these newsgroups since they started over 12
years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In
all
that time, I thought I was providing exactly the kind of help that you
seem
to be asking for.

I usually don't answer questions that I see have been answered by
another
MVP, nor to I give the man a fish when he wants to learn how to fish.
When I
point to a book, it's precisely because I know that the copyrighted code
is
in there or because a book was the question. I point to a website when I
or
someone else has written the code or an example, or when Microsoft has
written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what
you
want to hear. I usually won't give you code to do something that I know
is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

wrote in message

...



Over the years I have noted a significant difference between the XL
and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let
me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a
text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5
1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of
the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne

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.

wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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/ex...tributors.html
__________________________________________

"Bob Larson" wrote:

I think you need to take a bit of context into account when comparing the
Excel Newsgroups and Access Newsgroups. Excel is not concerned with
normalization and correct keys, etc. These are way more complex issues that
tend to permeate everything that gets posted around Access. So, many times
the explanation of these related items can take forever to write each time
so posting links to information is the only way to reasonably help someone
with those things. If they do have an immediate need, and that need would
be complicated by normalization issues, we don't necessarily give them the
quick, direct response because we are attempting to TEACH (albeit using
other resources than our own writing) as compared to giving them a band-aid
solution.

In fact, reusability is the reason why I created my website with "quick
tutorials" (tutorials basically from screenshots) so that I can communicate
with users around commonly asked questions without having to write the
answer over and over and over again.

Now, I know that there are those who just supply answers and never explain
them. I am guilty of that at times as well. That can also come from the
fact that we are volunteers who are trying to help but also have other
things in life to deal with. We can't always write a book of our own for
each post.

I'm sorry that you feel that we don't seem to fit into your ideal support
model.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com


wrote in message
...


Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne

I look back and see you've had lots of good answers to your many questions in
this group. This morning a troll bit you when you posted another one.
Instead of ignoring the troll, you go on a rant about the inadequacies of the
volunteers in these groups who help you and hundreds of others every day at
no cost to you.

Your reward for fueling the troll is that he'll consider you to be his pal.
(He loves Excel users, especially ones who complain about Access and the
people who answer questions in these groups). Now that he knows how much he
can irk you, he's going to keep doing it. Over and over.

Not sure which MS employee you're telling your organization is badmouthing MS
products, but you'd better check your facts first before you get caught
making false claims.

Chris
Microsoft MVP


wrote:
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?

More, I am sure that the 10,000+
Access users in my organization would not be happy campers if they knew that MS was badmouthing
there own product on their own forum - not real encouraging.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200807/1

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.


"Bob Larson" wrote:


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.

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.


On Jul 27, 6:22*pm, wrote:
At the end of the day have you made any positive progress in this Forum? *I think not.

a a r o n _ k e m p f wrote:

if you've been using Access for that long-- you'd be using SQL Server
by now. *I guarantee it.
Access is just a speed bump on the path towards SQL Server.

A pothole.
A driveway to the information super highway that is 'SQL Server'.

You're kidding yourself.
It is inconcievable that you have this much experience with Access and
yet you cannot spell SQL Server

On Jul 27, 5:45*pm, "Arvin Meyer [MVP]" wrote:
That's odd. I've been on these newsgroups since they started over 12 years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In all
that time, I thought I was providing exactly the kind of help that you seem
to be asking for.

I usually don't answer questions that I see have been answered by another
MVP, nor to I give the man a fish when he wants to learn how to fish. When I
point to a book, it's precisely because I know that the copyrighted code is
in there or because a book was the question. I point to a website when I or
someone else has written the code or an example, or when Microsoft has
written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what you
want to hear. I usually won't give you code to do something that I know is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...

wrote in message

. ..

Over the years I have noted a significant difference between the XL and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? *Or let me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a text
import).

* * * DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. *But let us be real. *If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5 1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. *Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne

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





On Jul 27, 7:56*pm, wrote:
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?

I am obviously not a significant Access user. *That said, what I am now working on is an idea which
will cause a significant improvement in information and decrease time in account reconciliation's.

I do not have the time right now to become an Access guru. *My questions were very simple and
answers were needed before tomorrow I had hoped.

The mission of this forum s/b to encourage Access use and proliferation.

I do not have PC-level access in my organization to SQL Server. *More, I am sure that the 10,000+
Access users in my organization would not be happy campers if they knew that MS was badmouthing
there own product on their own forum - not real encouraging.

Access is what we have and must use. *I was just looking for some real help.

Someone above has given answers

"Rick Brandt" wrote:
wrote:
Arvin,

You have helped and are one of the "good ones."

Where, pray tell, was an answer? *There is too much smoke.

Actually, my comments were to challenge not to provoke.

1) What is the VBA command to delete record #1, or #2 etc

There is no such thing as record #1, or record #2 in a database unless you
define what you mean by those descriptions. *The very question highly
suggests someone that doesn't know what they are doing. *You are then
surprised if you get requests for clarification rather than explicit
instructions?

2) Can anyone share a VBA macro to import a text file where there is
code examples to rename or name Field1 to "Whatever" and to set the
data type?

I for one have no idea about anything in this question. *"VBA Macro" does
not compute. *Most MVPs have little or no experience with macros (I
certainly don't). *Renaming fields via code is not something that would
often be done. *Neither is setting the data type. *Again the question highly
suggests that questionable actions are being performed so inquiring "why?"
is a perfectly natural thing to do.

I cannot believe that I cannot get useable answers *I get long self
aggrandizements which take far more time than the question.

I guess I am a bit frustrated.

Despite the level of expertise in here, not every answer is a matter of
pounding the keyboard. *Some (like yours) would require opening a test file
and actually working out an example. *At least if the one posting the answer
wanted to be sure it would be correct. *You expect someone to do that much
work when the desired action is questionable in the first place?

You get less of this in other types of groups because other software areas
do not have these types of issues. *Try spending some time in the HTML or
javascript groups. *The heavy responders in those groups make a regular
habit of tearing to shreds any post that even remotely suggests that the
poster is a rookie or hasn't done their homework prior to posting. *I have
never seen more considerate and helpful responders (as a group) than what is
found in the Access groups.

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




On Jul 27, 8:18*pm, "Bob Larson" wrote:
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.

wrote in message

...

At the end of the day have you made any positive progress in this Forum?
I think not.

a a r o n _ k e m p f wrote:

if you've been using Access for that long-- you'd be using SQL Server
by now. *I guarantee it.
Access is just a speed bump on the path towards SQL Server.

A pothole.
A driveway to the information super highway that is 'SQL Server'.

You're kidding yourself.
It is inconcievable that you have this much experience with Access and
yet you cannot spell SQL Server

On Jul 27, 5:45 pm, "Arvin Meyer [MVP]" wrote:
That's odd. I've been on these newsgroups since they started over 12
years
ago, and before that on the CompuServe Forums. This is my 8th year as an
Access MVP. Additionally, I operate the 3 Access websites in my sig. In
all
that time, I thought I was providing exactly the kind of help that you
seem
to be asking for.

I usually don't answer questions that I see have been answered by
another
MVP, nor to I give the man a fish when he wants to learn how to fish.
When I
point to a book, it's precisely because I know that the copyrighted code
is
in there or because a book was the question. I point to a website when I
or
someone else has written the code or an example, or when Microsoft has
written a KB article.

Because Access is a database, and a database is generally not a simple
thing, there is often no simple answer, or the answer may not be what
you
want to hear. I usually won't give you code to do something that I know
is
wrong.

So specifically, what is it that you are having a problem with?
--
Arvin Meyer, MCP,
MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...

wrote in message

...

Over the years I have noted a significant difference between the XL
and
the Access NG's

MS would be smart to suggest to its Access MVP's to teach both by
encouraging additional self
research coupled with real substantive immediate help.

i.e. if I ask:

Would someone supply a textfile import macro that I could edit? Or let
me
know how to "get to" the
saved import steps on 2007 for use in 2003?

or

I need the VBA code to delete the first three records (headers from a
text
import).

DoCmd.RunSQL "DELETE ???????

These answers are simple to Access professionals.

Sure links to additional sources are great. But let us be real. If you
went to a more knowledgable
person and asked a question that you knew he knew and he pointed to 5
1000
page books how would you
really feel?

Sometimes a simple answer to a simple question works. Access needs new
business and for others to
catch the creativity-motivation curve to solve immediate issues.

In short, answer questions with solutions not just additional projects
which distinguishes
motivation to use Access.

I realize that I may never get help again in Access NG's because of
the
hissy-fits which will
follow.

Stimulate! Encourage! Create! Help!

EagleOne

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




On Jul 27, 8:39*pm, "Arvin Meyer [MVP]" wrote:
wrote in message

...

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.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com