Jet driver version

"Amy Blankenship" wrote in
:

"David W. Fenton" wrote in message
. 1...

[]

Without any error messages, there's basically no help that anyone
can give you.

At this point there is no way to gather that information.

Then nobody is going to be able to help you.

What is the point
of posting to say you have no intention of being helpful?

I would be happy to offer advice if there were any information given
that would allow me to do so.

But there isn't, and you say there never will be.

How unprofessional of you to distribute a program without any error
reporting!

I mean, if you
were posting to say "I have a theory but it could be wrong" that
is one thing, but to post to say that your experience hasn't
prepared you to even offer an idea of what it could be is a waste
of everyone's time.

You're the one wasting people's time, seems to me.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

"David W. Fenton" wrote in message
. 1...
"Amy Blankenship" wrote in
:

"David W. Fenton" wrote in message
. 1...

[]

Without any error messages, there's basically no help that anyone
can give you.

At this point there is no way to gather that information.

Then nobody is going to be able to help you.

What is the point
of posting to say you have no intention of being helpful?

I would be happy to offer advice if there were any information given
that would allow me to do so.

But there isn't, and you say there never will be.

I actually said there would not be for _this_ user. Who knows when/if there
will be another user with a similar problem? However, I find it highly
unlikely that _no one_ on this forum has ever seen a failure of Jet of any
kind that they could share a few thoughts on.


How unprofessional of you to distribute a program without any error
reporting!

It has all kinds of error reporting. It does not have any error reporting
for _this_ situation, because it was not an error I thought I'd ever need to
trap for.

I mean, if you
were posting to say "I have a theory but it could be wrong" that
is one thing, but to post to say that your experience hasn't
prepared you to even offer an idea of what it could be is a waste
of everyone's time.

You're the one wasting people's time, seems to me.

You did not have to respond to my post. If you respond to a post, it looks
to others who might help as if the user is getting help, so unhelpful posts
are actually obstructive. If you can't provide productive input, it's
better not to create the appearance that you're helping.

Thanks;

Amy

Amy Blankenship wrote:
You did not have to respond to my post. If you respond to a post, it
looks to others who might help as if the user is getting help, so
unhelpful posts are actually obstructive. If you can't provide
productive input, it's better not to create the appearance that
you're helping.

These are discussion groups. You make a post and a discussion follows. If the
discussion proves to be helpful to you that is fine, but you do not get to
dictate the direction, participants, or content of the discussion. It might
feel like "your thread", but that is not the case.

As for your OP, an incompatible version of jet will simply not be able to work
with an MDB file at all. Jet that is the same version, but at a different patch
level might produce some artifacts, but proper queries returning no records
(when they should) without raising error messages is not anything that I have
heard of.

The only thing I can relate that sounds even remotely similar is that I have
seen queries against ODBC sources that are used as ListBox or ComboBox
RowSources fail with an ODBC error that is silent. By that I mean that the
error message that ought to be displayed is not, and the ListBox or ComboBox
simply has a blank list as if the RowSource query had no results.

I have only seen that with ODBC sources and in the Runtime environment so I
doubt that your users are seeing the same thing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"Rick Brandt" wrote in message
t...
Amy Blankenship wrote:
You did not have to respond to my post. If you respond to a post, it
looks to others who might help as if the user is getting help, so
unhelpful posts are actually obstructive. If you can't provide
productive input, it's better not to create the appearance that
you're helping.

These are discussion groups. You make a post and a discussion follows.
If the discussion proves to be helpful to you that is fine, but you do not
get to dictate the direction, participants, or content of the discussion.
It might feel like "your thread", but that is not the case.

You know, somehow I was under the impression it was a support forum.

As for your OP, an incompatible version of jet will simply not be able to
work with an MDB file at all. Jet that is the same version, but at a
different patch level might produce some artifacts, but proper queries
returning no records (when they should) without raising error messages is
not anything that I have heard of.

Oh I am sure it does raise error messages. But these messages are not
displayed to the user.

The only thing I can relate that sounds even remotely similar is that I
have seen queries against ODBC sources that are used as ListBox or
ComboBox RowSources fail with an ODBC error that is silent. By that I
mean that the error message that ought to be displayed is not, and the
ListBox or ComboBox simply has a blank list as if the RowSource query had
no results.

Sounds like you're thinking I'm using this from within an Access
application. I'm not.

I have only seen that with ODBC sources and in the Runtime environment so
I doubt that your users are seeing the same thing.

I'm frankly quite shocked that with such a huge user base, this product does
not seem to have users at a very high level of experience answering this
type of question. For instance, in slogging through all the KB articles
that are returned when you type in "DRIVER={Microsoft Access Driver (*.mdb)"
in the search window, I've discovered many interesting facts, for instance:

1) The jet engine starts up on launch of Access itself, but starts in
other applications only when a connection is made (and presumably halts when
the connection is released). This implies that the Jet engine does not need
a service running to be able to connect, but there may be unknown factors
involved concerning how that process works in terms of permissions, etc.
2) The jet engine has memory leaks
3) Some versions of Jet have a path length limitation of 85 bytes, which
may be the issue in this case.
4) Sometimes, the Jet engine can be installed in a different language and
thus may not be called "Microsoft Access Driver (*.mdb)", so attempts to
connect to it under that name will fail.
5) TechNet has a whole bunch of utilities that enable you to look at what
the system is doing under the hood so that you can determine whether
surmises such as I made in (1) are correct.

How is it that you guys don't know _any_ of this, as experts (and you are
one recognized by Microsoft as one)? Most of these facts had nothing at all
to do with any error messages someone might see, so presumably you weren't
holding back for lack of error messages on those.

-Amy

Hi, Amy.

All three of these points apply to your own post as well. Did you have
anything productive to add to the topic at hand?

Of course I do. Being rude and insulting to the many generous expert
volunteers who frequent these newsgroups and try to help those who need it
without charging a penny is one of the quickest ways to get the URL for the
$245 tech support from Microsoft, because your attitude isn't going to
compel very many experienced volunteers to jump to your aid in the future
after reading your messages, even though some of us could have fixed the
problem had it been anyone else's.

http://support.microsoft.com/oas/def...89&gprid=36052

Good luck.
Gunny


"Amy Blankenship" wrote in message
...

"'69 Camaro" AM wrote
in message ...
Hi, Amy.

if you were posting to say "I have a theory but it could be wrong" that
is one thing, but to post to say that your experience hasn't prepared
you to even offer an idea of what it could be is a waste of everyone's
time.

Here's a theory that's guaranteed to be 100% correct and very helpful to
someone in your shoes:

"You'll get further with honey than you do with vinegar."

I had several reasons for responding as I did:

1) Often, if you get peoples' adrenaline pumping by challenging them on
some level, something will spark in their memories that wouldn't if you
were sweet and nice.
2) He was not actually answering the question posed, so it's difficult
to worry if he's offended. I didn't ask for opinions on whether or not my
theory that Jet was the issue were right, but for people to share their
experiences of circumstances under which Jet might fail.
3) If people see a lot of responses on a thread, they are likely to
consider that the person is getting help and go to the next thread, even
if none of the responses are helpful in any way. So I consider it
extremely rude to answer a question with "No, I can't tell you the answer,
but I consider you stupid to have even asked."

All three of these points apply to your own post as well. Did you have
anything productive to add to the topic at hand?

Thanks;

Amy

"'69 Camaro" AM wrote in
message ...
Hi, Amy.

All three of these points apply to your own post as well. Did you have
anything productive to add to the topic at hand?

Of course I do. Being rude and insulting to the many generous expert
volunteers who frequent these newsgroups and try to help those who need it
without charging a penny is one of the quickest ways to get the URL for
the $245 tech support from Microsoft, because your attitude isn't going to
compel very many experienced volunteers to jump to your aid in the future
after reading your messages, even though some of us could have fixed the
problem had it been anyone else's.

http://support.microsoft.com/oas/def...89&gprid=36052

If they were actually trying to provide help I'd agree with you, but
unfortunately most of the replies on here have been somewhat in the vein of
"how stupid of you to even think it could be Jet." I say this with the
exception of Tony Toews, who does genuinely appear to be trying to work
towards a solution, and Douglas Steele, who was able to confirm my gut
feeling that Jet does not depend on any running services.

-Amy

On May 24, 3:21 am, "Amy Blankenship"
wrote:
"David W. Fenton"
You're the one wasting people's time, seems to me.

You did not have to respond to my post. If you respond to a post, it looks
to others who might help as if the user is getting help, so unhelpful posts
are actually obstructive. If you can't provide productive input, it's
better not to create the appearance that you're helping.

David W. Fenton taking the time to say that he isn't prepared to take
the time to answer the question? It's a feature, I'm afraid.

Q. What goes "Idiot. PLONK"?
A. David W. Fenton losing the argument.

Jamie.

--

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Jamie would never post such a message. Aaron
using the same IP address on this post as he does when he posts as
.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Jamie Collins" wrote in message
ps.com...
On May 24, 3:21 am, "Amy Blankenship"
wrote:
"David W. Fenton"
You're the one wasting people's time, seems to me.

You did not have to respond to my post. If you respond to a post, it
looks
to others who might help as if the user is getting help, so unhelpful
posts
are actually obstructive. If you can't provide productive input, it's
better not to create the appearance that you're helping.

David W. Fenton taking the time to say that he isn't prepared to take
the time to answer the question? It's a feature, I'm afraid.

Q. What goes "Idiot. PLONK"?
A. David W. Fenton losing the argument.

Jamie.

--

Oops! Pardon me. My mistake. Jamie Collins and
use the same computer in the UK. You picked a bad time to post when Aaron's
been busy impersonating others in the newsgroup, Jamie. I thought it was
him. You shouldn't have been posting under an assumed name so similar to
his, or I wouldn't have made the connection.

XMVP is available these days, if you care to post under another name. ;-)

Gunny


"'69 Camaro" AM wrote in
message ...
Everyone please note that Aaron Kem.pf is attempting to impersonate one
of our regular posters again. Jamie would never post such a message.
Aaron using the same IP address on this post as he does when he posts as
.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"Jamie Collins" wrote in message
ps.com...
On May 24, 3:21 am, "Amy Blankenship"
wrote:
"David W. Fenton"
You're the one wasting people's time, seems to me.

You did not have to respond to my post. If you respond to a post, it
looks
to others who might help as if the user is getting help, so unhelpful
posts
are actually obstructive. If you can't provide productive input, it's
better not to create the appearance that you're helping.

David W. Fenton taking the time to say that he isn't prepared to take
the time to answer the question? It's a feature, I'm afraid.

Q. What goes "Idiot. PLONK"?
A. David W. Fenton losing the argument.

Jamie.

--

On May 24, 9:33 am, "'69 Camaro" ForwardZERO_SPAM.To.
wrote:
Jamie would never post such a message.

Thanks for coming to my defence!

Q. What did the inflatable Principle say to the inflatable boy who
brought a pin into the inflatable school?
A. "You haven't just let yourself down, you've let me down, you've let
your friends down, you've let the whole school down..."

Jamie.

--